Solution for restoring MySQL Database root Password 2

The following article describes how to restore the root password of a MySQL database. The following describes how to restore the root password of a MySQL database. I hope to help you in this regard.

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.pid` 
 
 

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 passwordpassword =password(’yourpass’) where user=’root’ 
 
 

MySQL database;

 
 

  
  
shell>mysqladmin -u root flush-privileges password "newpassword"  
  
  
>use mysql  
  
  
>update user set passwordpassword=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. Hope to help you! The above content is an introduction to the root password of the MySQL database. I hope you will have some gains.