How to implement the statement to change user role password in MySQL?

How to implement the statement to change the user role password in MySQL?

In MySQL database management, it is occasionally necessary to change the user's role and password to maintain database security. Below we will introduce how to implement the statement to change the user role password in MySQL through specific code examples.

First, you need to log in to the root user in the MySQL database, and then follow the steps below.

1. Change user role:

If you need to change the user's role, such as upgrading an ordinary user to an administrator user, you can use the following statement:

GRANT role_name TO 'username'@'host';

Among them, role_name is the name of the role you want to grant, such as SELECT, INSERT, UPDATE, etc., username is the user you want to grant the role to, host is the host name of the user, you can use localhost.

For example, if you want to upgrade user testuser to a user with SELECT and UPDATE permissions, you can use the following statement:

GRANT SELECT, UPDATE ON database_name.* TO 'testuser'@'localhost';

2. Change user password:

If you need to change the user's password, you can use the following statement:

SET PASSWORD FOR 'username'@'host' = PASSWORD('new_password');

where username is you For the user who wants to change the password, host is the host name of the user, and new_password is the new password you want to set.

For example, if you want to set the password of user testuser to newpassword, you can use the following statement:

SET PASSWORD FOR 'testuser'@'localhost' = PASSWORD('newpassword');

It should be noted that, from MySQL Starting from version 5.7.6, the SET PASSWORD statement is deprecated. It is recommended to use the ALTER USER statement to change the user password:

ALTER USER 'username'@'host' IDENTIFIED BY 'new_password';

3. Revoke user role:

If you need to revoke the user's existing role, you can use the following statement:

REVOKE role_name FROM 'username'@'host';

For example, if you want to revoke the SELECT of user testuser and UPDATE permissions, you can use the following statement:

REVOKE SELECT, UPDATE ON database_name.* FROM 'testuser'@'localhost';

In short, changing user role passwords in MySQL is an integral part of managing database security. Through the above specific code examples, we can clearly understand how to implement these operations to better manage database permissions.

The above is the detailed content of How to implement the statement to change user role password in MySQL?. For more information, please follow other related articles on the PHP Chinese website!