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 mysql config file my.ini (not sure where to search), in [MYSQLD] This entry is added under
Skip-grant-tables
Save after exiting restart MySQL
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;
2. Set a new password to the root user, blue section enter it yourself:
mysql> Update user Set Password=password (" New Password ") where user=" root ";
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 to delete, save the exit and then restart MySQL.
MySQL ERROR 1045 (28000): Access denied for user resolves