- 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
