MySQL Error 1045 (28000): Wrong resolution

Entering mysql-uroot-p in CMD 1045 error appears as follows:

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using password)

Workaround:

1. Locate the My.ini file in the MySQL bin directory, and add skip-grant-tables under [MySQL] to skip the password (the last line placed in the My.ini file )

2. turn off the server (first is off)

net stop MySQL

3. Go to cmd, reset password

Mysql-uroot-p Enter

No Tube password Enter

Use MySQL; Enter

Change Password: Set password for ' root ' @ ' localhost ' =password (' new password '); (Bo Master These statements have tried, and finally the first fit, may wish to try more)

UPDATE user SET Password=password (' new password ') WHERE user= ' root ';

Update user set Password=password (" New password ") where user= "root";

Hint: Query OK, 1 rows affected (0.04 sec) rows matched:1 changed:1 warnings:0 (appears to prove successful)

Flush Privilegs; or FLUSH privileges; Refresh the database (some times you need to capitalize)

Hint: Query OK, 0 rows affected (0.01 sec) (appears to prove successful)

Quit or exit; or CTRL + C or Quitbye

4. Modify My.ini comment out skip-grant-tables; save exit

5. Restart the server net start MySQL

can refer to Laopan's blog-Address: https://www.cnblogs.com/jpwz/p/6061214.html (combined to do)

MySQL Error 1045 (28000): Wrong resolution