How to restore MySQL with a forgotten password

This article introduces how to restore the MySQL password after you forget the password. If you encounter this problem, you can refer to this article to retrieve the mysql password.

1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). The files that store the process ID are usually located in the directory of the MYSQL database.

The Code is as follows:	Copy code
Killall-TERM mysqld

You must be a UNIX root user or an equivalent user on the SERVER you run to perform this operation.
2. Use the '-- skip-grant-tables' parameter to start

The Code is as follows:	Copy code
Mysqld. (LINUX/usr/bin/safe_mysqld -- skip-grant-tables, windows c: mysqlbinmysqld -- skip-grant-tables)

3. log on to the mysqld server without a password,

The Code is as follows:	Copy code
> Use mysql > Update user set password = password ("new_pass") where user = "root "; > Flush privileges;

. You can also do this :'

The Code is as follows:	Copy code
Mysqladmin-h hostname-u user password 'new password ''.

 

4. Load the permission table:

The Code is as follows:	Copy code
'Mysqladmin-h hostname flush-privileges ', or use the SQL command 'flush privileges '. 5. killall-TERM mysqld

6. log in with a new password