In windows, mysql forgets the password, and mysql forgets the password.

In windows, mysql forgets the password, and mysql forgets the password.
In windows, what should I do if I forget my mysql password? I will give a case and explanation! Solve the problem! The actual operations in Windows are as follows: 1. Disable running MySQL. 2. Open the DOS window and go to the mysql \ bin directory. 3. Enter mysqld -- skip-grant-tables and press Enter. If no prompt is displayed, it is correct. 4. Open another DOS window (because the DOS window can no longer be moved) and go to the mysql \ bin directory. 5. enter mysql and press Enter. If successful, the MySQL prompt> www.2cto.com 6 will appear. connect to the permission database> usemysql; (> is the original prompt, don't forget the last semicolon) 6. change password:> update user set password = password ("123456") where user = "root"; (do not forget the last semicolon) 7. refresh permissions (required steps)> flush privileges; 8. exit> \ q 9. log out of the system, log on to MySQL, and log on to MySQL with the username root and the new password 123456.