Forgotten password MySQL recovery method

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.

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 are running to perform this operation.
2. Use '--skip-grant-tables ' parameter to start

The code is as follows	Copy Code
Mysqld (Linux under/usr/bin/safe_mysqld--skip-grant-tables, Windows C:mysqlbinmysqld--skip-grant-tables)

3. Then login to 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. Loading permission table:

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

6. Login with new password