Summary of root Password restoration methods for MySQL Databases

　　
-

Method 1

1. Download the MySQL source code distribution package. We don't need to differentiate the operating system. We need the same thing;


2. Rename the mysql folder in the data directory of your mysql database to oldmysql;

3. Copy the mysql directory under the data directory in the source code package to the data directory of your mysql;

4. Restart mysql. Now the mysql authorization relationship is the same as that of the new installation. log on with a blank password and adjust the authorization;

5. Open the database oldmysql to check what is going on;

6. If there is a backup, the integrity of the original database in the system will be checked to avoid modification.

Method 2

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.

Kill 'cat/mysql-data-directory/hostname. Pi'

You must be the root user of Linux or the same user on the SERVER where you are running;

Killall-TERM mysqld

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

Shell> mysqld_safe -- skip-grant-tables &

/Bin/safe_mysqld -- skip-grant-tables &


3. Use the 'mysql-h hostname mysql' command to log on to the mysqld server and use the grant command to change the password. You can also do this:

'Mysqladmin-h hostname-u user password' new password''

It can also be used

Use mysql; update user set password = password ('yourpass') where user = 'root'

;

Shell> mysqladmin-u root flush-privileges password "newpassword"

> Use mysql

> Update user set password = password ("new_pass") where user = "root ";

> Flush privileges;

4. Load the permission table:

`

Mysqladmin-h hostname flush-privileges'

Or use SQL commands

'Flush privileges'

Of course, you can restart mysqld here.