1 the actual operation under Windows is as follows2 3 1Shut down the service by shutting down the running MySQL. 4 5 2. Open the DOS window and go to the Mysql\bin directory. 6 7 3. Entermysqld-- skip-grant-tables Enter. If the message doesn't appear, it's right. 8 9 4to open a DOS window (because the DOS window is no longer moving), go to the Mysql\bin directory. Ten One 5Input MySQL Enter, if successful, the MySQL prompt will appear> A - 6. Connection Rights Database> UseMySQL (>is the original cue, do not forget the last semicolon) - the 6. Change Password:> Update User SetPassword=Password ("123")where User="Root"; (Don't forget the last semicolon) - - 7. Refresh permissions (required steps)>FlushPrivileges; - + 8. exit>\q - + 9Log off the system, then enter, open MySQL, use the username root and just set the new password 123 to login.
Note: Transfer from online
MySQL reset password under Windows