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

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

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

This is the same bug as Bug #11822.

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.