MySQL password modification example detailed explanation

Shut down the MySQL service: net stop MySQL
Open a cmd console window as an administrator, enter the bin directory where MySQL is located, and execute mysqld --skip-grant-tables
Open another cmd window and execute the mysql command directly (since the 2nd operation can access the table without authorization, you can log in directly with mysql without a username and password)
Switch to mysql database: uses mysql;
Modify the password field of the user table: update user set password = password ( '123456' ) where user = 'root';
Perform the refresh operation: flush privileges; 
Exit mysql: quit;
Restart the MySQL service: net start MySQL