Linux forgot MySQL password to retrieve the method

0. Environment

Ubuntu 12.04 x64 Server

MySQL 5.5.29

1. Steps

1.1 Modify your MySQL ' s "my.cnf" file, and add a line in "[Mysqld]" session:
Skip-grant-tables

1.2 Restart MySQL

1.3 Log in MySQL without password
$ bin/mysql-u Root-p
Press ENTER when the command shows "Enter Password:"

1.4 Select Database
mysql> use MySQL;

1.5 updata Password
mysql> Update user Set password = password (' mypass ') where user = ' root ';

1.6 Refresh tables related with system permissionmysql> flush privileges;

1.7 Modify your MySQL ' s "my.cnf" file to original version, delete the following line in "[Mysqld]" session:skip-grant-tabl Es

1.8 Restart MySQL