MySQL Root password recovery

1. Stop MySQL Service

Service MySQL Stop

2, start MySQL does not start the authorization table, skip permission to authenticate with a blank password login

Mysqld_safe--skip-grant-tables &

3. Log in to MySQL

Mysql-uroot-p

4. Set the root user password for MySQL to 123456

Update Mysql.user Set Password=password ("123456") where user= "root";

5. Force MySQL Reload permissions

Flush privileges;

6. Exit and restart MySQL

Exitservice MySQL Restart

7. Log in to MySQL

mysql-uroot-p123456

8. Reset Root Password

Executing any MySQL command at this time will report the following error 1820 (HY000): Must SET PASSWORD before executing this statement

Set Password=password (' 123456 ');

MySQL Root password recovery