Forgot to modify MySQL password under Windows

1. Locate the MySQL configuration file My.ini
2. Add Skip-grant-tables under [mysqld]
3. Win+r shortcut key Input cmd then enter the command net stop MySQL finally make the directory point to the bin directory in the MySQL installation directory
4. Input command mysqld-nt--skip-grant-tables (local test hint a waring doesn't seem to affect)
5. Win+r the shortcut key again enter CMD and enter the command mysql-u root return, this time should enter MySQL
6. Select Database user mysql;
7. Change Password: Update user set Password=password ("New password") where user= ' root '; Note The uppercase password is encrypted with the new password three words replaced with their own password
8. Kill the MYSQLD-NT process in Task Manager
9. Delete the content added in the second item
10. Restart MySQL
11. Enter new password detection.

Forgot to modify MySQL password under Windows