Jump to content


Photo

WHAT HAPPENED?! :-(


  • Please log in to reply
5 replies to this topic

#1 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 06 April 2003 - 06:09 PM

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.

:cry:

(And there is a password for my MySQL databases)
DEFINE("YOU","Spending Too Much Time On The Computer");

#2 Kriek

Kriek
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationFlorida

Posted 06 April 2003 - 07:37 PM

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.
Jon Kriek · PHP Freaks
Sometimes the need to mess with their heads ...
... outweighs the millstone of humiliation.


#3 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 06 April 2003 - 09:12 PM

All of the databases listed except mine are empty. How about yours?
DEFINE("YOU","Spending Too Much Time On The Computer");

#4 Kriek

Kriek
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationFlorida

Posted 06 April 2003 - 09:20 PM

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.
Jon Kriek · PHP Freaks
Sometimes the need to mess with their heads ...
... outweighs the millstone of humiliation.


#5 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 06 April 2003 - 09:51 PM

Er... where exactly would I run that?
DEFINE("YOU","Spending Too Much Time On The Computer");

#6 Kriek

Kriek
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationFlorida

Posted 06 April 2003 - 10:53 PM

Make sure the MySQL root pass is the same as the server pass.

Then run it through PuTTY on ssh/telnet
Jon Kriek · PHP Freaks
Sometimes the need to mess with their heads ...
... outweighs the millstone of humiliation.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users