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: | |
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
[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".