Avalanche Posted April 6, 2003 Share Posted April 6, 2003 I was following MySQL tutorials, and when I want to edit my databases with phpMyAdmin I found 100-300 databases in my list on the left! When I look at the other page (the one my host has), there are only the databases that I created. When I look at the phpMyAdmin page, there are tons and tons of them. If I try to delete any of them it says that the access was denied. So... did someone crack into my databases or is it just displaying other people\'s databases for some reason? It scares the crap out of me that there are 100s of databases that I didn\'t create... But there are tons and tons of different preceding names, so I don\'t think all of them would happen to get the MySQL info for my host and create all their databases in one night. (And there is a password for my MySQL databases) Quote Link to comment Share on other sites More sharing options...
Kriek Posted April 6, 2003 Share Posted April 6, 2003 This is happening to my server as well. I have no idea what is causing it, although we all seem to be connecting to localhost which normally wouldn\'t cause a problem. Quote Link to comment Share on other sites More sharing options...
Avalanche Posted April 6, 2003 Author Share Posted April 6, 2003 All of the databases listed except mine are empty. How about yours? Quote Link to comment Share on other sites More sharing options...
Kriek Posted April 6, 2003 Share Posted April 6, 2003 This will fix it! /usr/bin/mysql_fix_privilege_tables Make sure to login as root and run this command. After running the command stop and start MySQL. You might need to logout of your phpMyAdmin, then log back in order to see the changes. Quote Link to comment Share on other sites More sharing options...
Avalanche Posted April 6, 2003 Author Share Posted April 6, 2003 Er... where exactly would I run that? Quote Link to comment Share on other sites More sharing options...
Kriek Posted April 6, 2003 Share Posted April 6, 2003 Make sure the MySQL root pass is the same as the server pass. Then run it through PuTTY on ssh/telnet Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.