Forgot the MySQL root password reset method

If you forget the MySQL root password, you can reset it in the following ways:

1. Kill off the MySQL process in the system;

2. Use the following command to start MySQL, to do not check the permissions of the way to start;

Mysqld_safe-skip-grant-tables &

3. Then use the null password method to log in to MySQL with root user;

Mysql-u Root

4. Change the password of root user;

mysql> Update Mysql.user Set Password=password (' New password ') where user= ' root ';

mysql> flush Privileges;

Mysql> quit

5. Restart MySQL, you can log in with the new password.

The above is the use of SQL commands to implement, in fact, we can also change the user password by replacing the MySQL using performance is similar to, I used to (under the same version of MySQL did replace MySQL database this practice, if the database inside the database is different do not operate).