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
