How to restore the MySQL root password

If you forget your MySQL root password, you can recover it through the following procedure.

1. Send Kill command to MYSQLD server to turn off MYSQLD server (not kill-9), and the file that holds the process ID is usually in the directory where the MySQL database resides.

Kill ' Cat/mysql-data-directory/hostname.pid '

You must be a UNIX root user or an equivalent user on the server you are running to perform this operation.

2. Use the--skip-grant-tables parameter to start the mysqld.

3. Log on to the MYSQLD server using the mysql-h hostname mysql command and change the password with the grant command. You can also do this: mysqladmin-h hostname-u user password new password.

In fact, you can use MySQL; Update user Set Password =password (yourpass) where user=root to do so.

4. Load permission table: ' mysqladmin-h hostname flush-privileges, or use SQL command ' flush privileges.

Of course, here, you can also restart mysqld.