Solve the Problem of forgetting the MySQL root Password

The following articles mainly describe the actual solution for forgetting the MySQL root Password. MySQL root Password is often used in practical applications. If you accidentally lose the root password, you can use our article to better understand MySQL root Password restoration.

One of the methods to restore the MySQL root Password

If you forget the MySQL root Password, use the following method to reset it:

1. KILL the MySQL process in the system;

 
 

  
  
killall -TERM MySQLd  
 
 

2. Run the following command to start MySQL without checking its permissions;

 
 

  
  
safe_MySQLd --skip-grant-tables &  
 
 

3. Use the empty password to log on to MySQL as the root user;

 
 

  
  
MySQL -u root  
 
 

4. Modify the password of the root user;

 
 

  
  
MySQL> update MySQL. user set password = PASSWORD ('new password') where User = 'root ';
  
  
MySQL> flush privileges;
  
  
MySQL> quit
 
 

Restart MySQL to log on with the new password.

MySQLRoot Password restoration method 2

It is possible that your system does not have the safe_MySQLd Program (for example, I am using the ubuntu operating system, MySQL installed with apt-get). The following method can be restored:

1. Stop MySQLd;

 
 

  
  
sudo /etc/init.d/MySQL stop 
 
 

(You may have other methods. Simply stop running MySQLd)

2. Run the following command to start MySQL without checking its permissions;

 
 

  
  
MySQLd --skip-grant-tables & 
 
 

3. Use the empty password to log on to MySQL as the root user;

 
 

  
  
MySQL -u root 
 
 

4. Modify the password of the root user;

 
 

  
  
MySQL> update MySQL.user set password=PASSWORD('newpassword') where User='root';   
  
  
MySQL> flush privileges;   
  
  
MySQL> quit  
 
 

Restart MySQL

 
 

  
  
/etc/init.d/MySQL restart 
 
 

You can use the new password newpassword to log on.

The above content is an introduction to the solution to the problem of forgetting the MySQL root password. I hope you will gain some benefits.