Recover administrator password when MySQL forgot password

# service MySQL Stop

# service Mysqlstart--skip-grant-tables//Skip Authorization form to start the MySQL service program

# mysql-u root//password login not required

mysql> Update Mysql.user Set Password=password (' 123456 ') where host= "localhost"; Reset passwords by modifying related records in the user table in the MySQL library

Query OK, 0 rows affected (0.38 sec)

Rows matched:1 changed:0 warnings:0

mysql> flush Privileges; Refresh Authorization Table

Query OK, 0 rows affected (0.14 sec)

# service MySQL restart//restart services

# mysql-hlocalhost-uroot-p123456//Login with new password

Mysql>