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

[30 Mar 2006 20:48] Roopa Sharma
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
[30 Mar 2006 20:56] Valeriy Kravchuk
Thank you for a problem report. Please, specify the exact mysql command line you used to connect.
[30 Mar 2006 21:19] Roopa Sharma
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
[31 Mar 2006 7:39] Valeriy Kravchuk
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.
[31 Mar 2006 14:34] Roopa Sharma
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
[31 Mar 2006 15:40] Valeriy Kravchuk
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.
[31 Mar 2006 15:42] Roopa Sharma
This is what i get:

>mysql -u root -pmypass
ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
[2 Apr 2006 7:49] Valeriy Kravchuk
Please, send the results of:

select user, host from mysql.user\G
[2 May 2006 23:00] Bugs System
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".