MySQL Bugs: #18666: Change root password - cannot connect to server

Bug #18666	Change root password - cannot connect to server
Submitted:	30 Mar 2006 20:48	Modified:	2 May 2006 7:49
Reporter:	Roopa Sharma	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.19	OS:	Windows (Windows XP Pro)
Assigned to:		CPU Architecture:	Any

Description:
I installed MYSQL 5.0.19 and was working without any problems until I decided to change the root password on the server.

I checked online and used the following steps to change the password.

mysql> UPDATE user SET Password=PASSWORD('mypass') WHERE User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye

After this, I could not connect to the sever at all:

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server

I tried using the mysqladmin, but without any results.

How to repeat:
change password like this:
mysql> UPDATE user SET Password=PASSWORD('mypass') WHERE User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye

Try to connect to the server after this, it won't let you connect

Thank you for a problem report. Please, specify the exact mysql command line you used to connect.

i treied these commands:

1. mysql -u root -p <database name>

2. mysql -u root -p

3. I even tried reconfiguring from the "MYSQL server instance config" wizard, but came across the same error

And you typed mypass when prompted for password, aren't you? I ask because I just tried your test case with 5.0.19 on XP, and was able to login as root with mypass password.

I did enter the correct password, but got the same error message:

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server

Infact I tried both the old password and new password several times.

Did I do anything wrong while changing the password?

mysql> UPDATE user SET Password=PASSWORD('mypass') WHERE User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye

Everithing is OK with changing password that way. Please, send the exact results of

mysql -u root -pmypass

after that. Jusdt copy and paste, as for the previous commands. I was not able to repeat the behaviour you described.

This is what i get:

>mysql -u root -pmypass
ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server

Please, send the results of:

select user, host from mysql.user\G

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".