I am by no means an expert (even remotely) but I do recall instructions
on exactly how to do this in the documentation for MySQL - I think
under the how to upgrade section.
- Charles
On Monday, March 3, 2003, at 06:53 PM, Stephen Craton wrote:
Hello,
Yesturday I made a big mistake. I had to import a 60MB file into a
database
and I used ssh. I'm very unfamiliar with it and when I connected to the
MySQL connection thing, I forgot to switch databases when I imported.
This
overwrite (I don't know why but it did) the users table in the mysql
database and caused everything to get messy.
For some reason, though, the sites on the server are still working with
their old MySQL username and password (I'm not sure why since I
imported a
fresh install's mysql database from my local server). Everything seems
to be
working except phpMyAdmin. When I try logging in using the default
user as
root and password as nothing, it gives me an access denied error. It
does
this for every user we had in the database as well. Is there anyway I
can
fix this is ssh? The only option I can think of is reinstalling MySQL
but
even then we'll loose all the old databases and I'm not sure how to
export
the tables to a file in ssh.
Any help here would be most obliging and I need a reply rather
urgently in
order to allow my hosted sites access to phpMyAdmin once again...
Thanks,
Stephen Craton
http://www.melchior.us
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
