1. Close the running MySQL.
2. Open the DOS window and go to the Mysql\bin directory.
3. Enter Mysqld--skip-grant-tables carriage return. If the message doesn't appear, it's right. (The normal situation is that the cursor blinks without any hint, if not, the second method is executed)
4. Open a DOS window again (because the DOS window is no longer moving), go to the Mysql\bin directory.
5. Enter MySQL return, if successful, a MySQL prompt will appear <
6. Connection rights database <use MySQL; (< is the original cue, don't forget the last semicolon)
6. Change Password: Update mysql.user set Authentication_string=password (' root ') where user= ' root ';(don't forget the last semicolon)
7. Refresh permissions (required steps) <flush privileges;
8.\q exit;
Latest MySQL Login error "Access denied for user ' root ' @ ' localhost ' (using password:no" processing method)