#1130 - Host 'localhost' is not allowed to connect to this MySQL server

[Preston McMurry]

Took off the holiday (here in the USA) weekend. Came back. Booted up. Couldn't connect to my localhost mySQL database. Here is the message:

#1130 - Host 'localhost' is not allowed to connect to this MySQL server

WinXP sp2 (with latest patches as of mid-August)
mySQL 4.1.9
phpMyAdmin 2.6.0-pl3

I get the same error from the command line:

mysql -h localhost -u root -p
ERROR 1130 HY000 Host 'localhost' is not allowed to connect to this MySQL server

I don't see much around the web, other than a whole bunch of mySQL error code listings. (But not how to fix them.)

The only thing I find here on the mySQL Mothership are two bug reports: http://bugs.mysql.com/bug.php?id=4242 and http://bugs.mysql.com/bug.php?id=11822 , but nothing about to fix the situation. (Which apparently is a missing mysql.user meta table.)

Could the situation perhaps have been caused by me having a yadda.user table in my yadda database?

http://prestonm.com ... http://www.mcmurry.com