Mysql root Account Logon in Win7: ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES) solution,

Mysql root Account Logon in Win7: ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES) solution,

ERROR 1045 (28000): Ac ...... Password: YES) if the password is incorrect, change the password:

If your server is windows xp/2000/2003/nt, you can use this method to retrieve the lost MYSQL super administrator root password.

If there is no mysqld-nt.exein the region behind mysql 5.1in win7 win vista, use mysqld.exe instead.
1. stop MYSQL. Open the DOS window in CMD (right-click "Run with Administrator Account" in win7 and winVista) and enter net stop mysql.

2. In the CMD command line window, enter the MYSQL installation directory, for example, C: \ Program Files \ MySQL Server 5.1 \ bin.

Method: cd \ press enter and enter: cd C: \ Program Files \ MySQL Server 5.1 \ bin

3. Enter the mysql security mode, that is, when mysql is up, it can enter the database without entering the password.

Command: mysqld-nt -- skip-grant-tables

(Windows 7 seems to be wrong. skip this step without any concerns ,)
4. Open a new CMD command line window and enter... in \ bin, enter mysql-uroot-p and log on to MySQL with a blank password (Press enter without entering the password)

 
5. Enter the following command to modify the password of the root user (Note: There is a "point" in the middle of mysql. user ")
Mysql> update mysql. user set password = PASSWORD ('new password') where User = 'root ';

6. Refresh the permission table
Mysql> flush privileges;
7. Exit
Mysql> quit

So MYSQL super Administrator account ROOT has been reset, then in the task manager to end the mysql-nt.exe this process, restart MYSQL! (You can also restart the server)
After MYSQL is restarted, you can log on to MYSQL with the newly set ROOT password!

 

Reference: http://zongquansheng517.blog.163.com/blog/static/90047628201142282234423/