MySQL operation-forgot root account password

When the root user password for MySQL is forgotten, it can be reset by following these steps (executed under the CMD window of Administrator privileges)

1. Turn off the startup MySQL service

net stop MySQL

2. Perform the following command to avoid entering MySQL

Mysqld-nt--skip-grant-tables

3. Reopen admin cmd execute the following command to enter MySQL, no password required at this time

Mysql-u root-p

4. Commands to view legacy passwords

Select Host,user,password from Mysql.user;

5. command to change Password

Use MySQL;

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

Flush privileges;

6. Restart the MySQL service

Normal cmd execution: net start MySQL

PowerShell execution: Restart-service MySQL

　　PS: If the service cannot be restarted by command, try restarting the computer

MySQL operation-forgot root account password