Procedure for resetting the MySQL Database Password

The following articles mainly discuss the actual operation steps for resetting the MySQL database password, including how to stop the running MySQL database process, and the actual operation steps for starting MySQL in safe mode. After the operation is complete, you do not need a password to enter the description of MySQL.

Forgot to reset the MySQL Database Password

1. Stop the running MySQL process

In Linux, run killall-TERM MySQLd

In Windows, if it is written as a service, you can run: net stop MySQL. If it is not loaded as a service, you can directly close it in the Process Manager.

2. Start MySQL in Safe Mode

Run/usr/local/mysql/bin/mysqld_safe -- skip-grant-tables &

In Windows, run X:/MySQL/bin/mysqld-nt.exe -- skip-grant-tables on the command line

3. You will be able to access MySQL without a password.

In Linux, run/usr/local/mysql/bin/mysql-u root-p to enter

In Windows, run X:/MySQL/bin/mysql-u root-p to enter

4. Change the MySQL Database Password

 
 

  
  
> Use mysql
  
  
> Update user set passwordpassword = password ("new password") where user = "root ";
  
  
> Flush privileges;
 
 

Note: For version 4.1 or later, use the old_password () function to change the password.

The above content is an introduction to Resetting the MySQL database password. I hope you will get some benefits.