MySQL Reset password under Windows

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