#1045-Access denied for user 'root' @ 'localhost'

In Windows, the solution is as follows:

1. net stop MySQL Stop Service

2. Modify the my. ini file in the $ {mysql_home}/MySQL Server 5.1 directory.

[Mysqld] Add the following sentence:
Skip_grant_tables

3. Add your $ {mysql_home} \ bin directory to the path

4. Net start MySQL Service

5. mysql-uroot-P
Enter Password: Root

6. use MySQL;

Mysql> Update user SET Password = PASSWORD ('root') where user = 'root ';
Mysql> flush privileges;
Mysql> exit

7. Delete this sentence in my. ini: skip_grant_tables
Net stop MySQL
Net start MySQL

8. You can log on.

Mysql-uroot-proot
Mysql>