Windows forgot MySQL Password retrieve method

Only under Windows, I won't Linux, hey

1,net stop MySQL stopped MySQL service

2, the implementation of Mysqld-nt--skip-grant-tables

This starts, does not need the MySQL database password to be able to enter the MySQL

3, at this time to open a new command window, the implementation of MySQL, into MySQL

4, modify the root password

There's a:mysql> to be seen.

The code is as follows	Copy Code
Use MySQL Update user set Passwordpassword=password (' Your new password ') where user= ' root '; Flush privileges;

5. Kill Mysqld-nt Process in Task Manager

6,net start MySQL restart MySQL can