Summary of six measures for changing the MySQL password in the MySQL database

MySQL database, We sometimes needModify MySQL passwordTo ensure database security. There are usually many ways to change the password, and it is easy to implement. This article summarizes six methods to change the MySQL password. These six methods can be implemented only when the MySQL database has the ROOT permission. Next we will introduce these six measures.

Measure 1:Phpmyadmin is the easiest way to fix the user table in the mysql database. Do not forget to use the PASSWORD function.

Measure 2:Use mysqladmin, which is a special case stated above. Mysqladmin-u root-p password mypasswd after entering this call, you must enter the original root password, and then change the root password to mypasswd. Change the root user name in the call to your username, and you will be able to change your password. Of course, in case your mysqladmin cannot connect to the mysql server, you may not have taken any measures to enforce mysqladmin, even if this measure is ineffective. In addition, mysqladmin cannot clear the password.

Note: The following measures are used in the mysql reminder, and the root permission of mysqlkcitrust.com must be available:

Measure 3:

 
 

  
  
mysql> INSERT INTO mysql.user (Host,User,Password) VALUES('%','jeffrey',PASSWORD('biscuit'));   
  
  
 
  
  
mysql> FLUSH PRIVILEGES 
 
 

Accurately speaking, this is an additional user, with the username jeffrey and password biscuit. I wrote this example in mysql Chinese reference manual. Be careful to use the PASSWORD function, and then use flush privileges.

Measure 4:The REPLACE statement is used

 
 

  
  
mysql> REPLACE INTO mysql.user (Host,User,Password) VALUES('%','jeffrey',PASSWORD('biscuit'));   
  
  
 
  
  
mysql> FLUSH PRIVILEGES 
 
 

Measure 5:Use the set password statement

 
 

  
  
mysql> SET PASSWORD FOR jeffrey@"%" = PASSWORD('biscuit');  
 
 

You must also use the PASSWORD () function, but you do not need to use flush privileges.

Measure 6:Use the GRANT... identified by statement

 
 

  
  
mysql> GRANT USAGE ON *.* TO jeffrey@"%" IDENTIFIED BY 'biscuit';  
 
 

Here, the PASSWORD () function is not required, and you do not need to use flush privileges.

Note: PASSWORD () is not encrypted using the same measures as the Unix PASSWORD.

Here is an overview of the MySQL database's measures to correct the MySQL password. If you want to learn more about the MySQL database, please refer to the article http://database.51cto.com/mysql/, which will surely bring you the opportunity.