Troubleshoot MySQL forgot password in Windows MySQL sometimes forget the password what to do? I give the case and description! The actual operation under Windows is as follows 1. Close the running MySQL. 2. Open the DOS window and go to the Mysql\bin directory. 3. Enter Mysqld--skip-grant-tables carriage return. If the message doesn't appear, it's right. 4. Open a DOS window again (because the DOS window is no longer moving), go to the Mysql\bin directory. 5. Enter MySQL return and, if successful, the MySQL prompt > www.2cto.com 6 will appear. Connection Rights Database >usemysql; (> is the original cue, don't forget the last semicolon) 6. Change Password:> update user set Password=password ("123456") where user= "root"; (Don't forget the last semicolon) 7. Refresh permissions (required steps) >flush privileges; 8. Exit > \q 9. Log out of the system, then enter, open MySQL, use the username root and just set the new password 123456 login.
Troubleshoot MySQL forgot password under windows
