Bug #12188 Server gives error 1130 Host not Allowed error for root@localhost by default
Submitted: 26 Jul 2005 21:53 Modified: 27 Jul 2005 16:36
Reporter: Mike Hillyer Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.0.10 OS:Windows (Windows 2000 SP4)
Assigned to: Assigned Account CPU Architecture:Any

[26 Jul 2005 21:53] Mike Hillyer
Description:
A fresh install of MySQL 5.0.10 (taken early from a mirror before the announcement) will fail to configure with a new password.

Further investigation shows that using root with a blank password from localhost produces the following:

C:\Documents and Settings\Mike Hillyer>mysql -u root
ERROR 1130 (HY000): #HY000Host '127.0.0.1' is not allowed to connect to this MySQL server

This is what causes the configuration wizard to fail when setting the root password.

Starting the server with --skip-grant-tables alleviates the problem.

How to repeat:
Install a fresh copy of 5.0.10, try to set the root password with the configuration wizard. Failing that, try to connect to the server from localhost as root, no password.

Suggested fix:
Unknown
[26 Jul 2005 23:36] MySQL Verification Team
E:\Documents and Settings\miguel\bin>mysql -uroot
ERROR 1130 (HY000): Host '127.0.0.1' is not allowed to connect to this MySQL server
[27 Jul 2005 16:36] Jim Winstead
This is the same bug as Bug #11822.