Mysqlroot Password recovery under Linux

1. Modify the MySQL configuration file my.cnf

VI my.cnf

Add content under the [Mysqld] tab: Skip-grant-tables

2. Restart the MySQL service

Service mysqld Restart

3. Log in to MySQL

Mysql-u root-p

Prompt for password, enter directly to log in to MySQL

4. Change the root password and submit

Update Mysql.user set Password=password (' New password ') where user= ' root ';

Flush privileges;

5. Unregister skip-grant-tables content from the my.cnf file

VI my.cnf

#skip-grant-tables

6. Restart MySQL

Mysqlroot Password recovery under Linux