Shulou(Shulou.com)06/01 Report--

Editor to share with you what is the operation of MySQL to change the user's password, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

In MySQL, you can use three different statements to change the user account password:

UPDATE statementSET PASSWORD statementALTER USER statement.

But before changing your account password, there are two very important things to keep in mind:

-user account details for which you want to change the password.

-the user who wants to change the password is using the application because if the password is changed without changing the connection string of the application, the application will not be able to connect to the database server.

Now let's learn how to change a user's password in SQL using the three SQL statements mentioned above:

1. Use the SET PASSWORD statement to change the MySQL user password

To use the SET PASSWORD statement to change a user's password, the first requirement is that the account must have at least UPDATE privileges.

The user account should be in the format "user @ host" and you need to update its password.

To change the password of the user account "gfguser1" to "newpass" using the SET PASSWORD statement, execute the following code statement:

Syntax:

two。 Use the ALTER USER statement to change the MySQL user password

The second way to change the password of a user account is to use the ALTER USER statement.

The ALTER USER statement is used with the "IDENTIFIED BY" clause.

To change the password of the user account "gfguser1" to "newpass" using the Alter User statement, the syntax is as follows:

Syntax:

3. Use the update statement to change the MySQL user password

The third way to change the user account password is to use the update statement.

The Update statement updates the user table of the mysql database.

The FLUSH PRIVILEGES statement needs to be executed after the UPDATE statement is executed.

The FLUSH PRIVILEGES statement is used to reload permissions from the grant table in the mysql database.

To change the password of the user account "gfguser1" to "newpass" connected from the localhost server, the syntax is as follows:

Syntax:

The above is all the contents of what is the operation method of MySQL to change the user's password, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.