MySQL ERROR 1045 (28000): Access denied for user workaround

Problem Recurrence (The following discussion is for Windows environments only):

C:\appserv\mysql> Mysql-u Root-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Edit the MySQL profile My.ini(do not know where to search), add under [mysqld] This entry
Skip-grant-tables
Restart MySQL after saving exit

1. Click "Start", "Run" (shortcut key Win+r).

2. Start: Enter net stop MySQL

3. Stop: Enter net start MySQL

At this time in the cmd input mysql-u root-p can be used without password login, appear password: when the direct return can enter, will not appear error 1045 (28000), but many operations will be limited, Because we can't grant (without permission). Follow the process below (the red part is the input section, the pink One is the code shown after the execution does not have to be entered):

1. Go to MySQL database:

mysql> use MySQL;
Database changed

2. Set a new password for the root user, and enter the blue part yourself:
mysql> Update user Set Password=password (" New password ") where user= "root";
Query OK, 1 rows affected (0.01 sec)
Rows matched:1 changed:1 warnings:0

3. Refreshing the database
mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)

4. Exit MySQL:
Mysql> quit
Bye

After the change, and then modify the My.ini this file, we just joined the "skip-grant-tables" This line delete, save exit and restart MySQL can be

Http://blog.sina.com.cn/s/blog_759a5a7c01017dj0.html

MySQL ERROR 1045 (28000): Access denied for user workaround