Test availability after MySQL forgets its password

Step 1 @ open CMD and run the command net stop MySQL to stop the MySQL Service

Step 2 @ go to the bin folder of the MySQL installation directory and run mysqld-NT -- skip-grant-tables

(The purpose is to skip password detection) do not close the CMD window

Step 3 @ open the CMD window and run the MySQL Command use MySQL

Select MySQL database

Run the SQL statement to change the password: update user SET Password = PASSWORD ('000000') where user = '000000 ';

 

Fourth @ run the command flush privileges;

When rows 1 access... appears .... It indicates that the modification is successful. OK

This is a success !!!!!!