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) Link to comment https://forums.phpfreaks.com/topic/313-what-happened/ 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. Link to comment https://forums.phpfreaks.com/topic/313-what-happened/#findComment-1001 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? Link to comment https://forums.phpfreaks.com/topic/313-what-happened/#findComment-1004 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. Link to comment https://forums.phpfreaks.com/topic/313-what-happened/#findComment-1005 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? Link to comment https://forums.phpfreaks.com/topic/313-what-happened/#findComment-1008 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 Link to comment https://forums.phpfreaks.com/topic/313-what-happened/#findComment-1009 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.