Linux Mysql root password forgotten, initialized

Some time ago a test environment of the MySQL database root password can not be found, an unimportant library, the installer was negligent ... Restore the password manually. Write down a note.

1. Enter my.cnf and add Skip-grant-tables in the [mysqld] field

2. Restart MySQL service mysqld restart

3, no password to enter MySQL password change

Mysql-uroot-p

MySQL > Update mysql.user set Password=password (' New PASSWORD ') where user= ' root '

Mysql>flush Privileges

Mysql>quit

4. Delete the skip-grant-tables in mysql.cnf

5. Restart MySQL Service

Service mysqld Restart

Get!

Linux Mysql root password forgotten, initialized