How to implement the statement of authorized users in MySQL?

How to implement the statement of authorized users in MySQL?
MySQL is a widely used relational database management system. By using authorization statements, users' access rights to the database can be controlled. In this article, we will introduce how to implement the statement of authorized users in MySQL through specific code examples.

In MySQL, you can use the GRANT statement to implement authorized user operations. The GRANT statement allows users to perform specific operations, such as SELECT, INSERT, UPDATE, DELETE, and CREATE, etc., and can also set the databases and tables that users can access.

The following is an example that shows how to use the GRANT statement to create a new user and grant it SELECT and INSERT permissions on a specific database:

GRANT SELECT, INSERT ON database_name.* TO 'new_username'@'localhost' IDENTIFIED BY 'password';

The above statement is divided into several parts:

• GRANT: Indicates authorization operation.
• SELECT, INSERT: Specifies the operations that the user is allowed to perform. Multiple operations can be set as needed.
• database_name.: Indicates the databases and tables that the user is granted access to, indicates all tables.
• 'new_username'@'localhost': Specifies the username and access host of the new user, which can be changed according to the actual situation.
• IDENTIFIED BY 'password': Set the password of the new user.

In addition to granting permissions to a specific database, you can also use the GRANT statement to grant users permissions on specific tables. Below is an example that shows how to grant SELECT and UPDATE permissions to a user on a specific table:

GRANT SELECT, UPDATE ON database_name.table_name TO 'new_username'@'localhost';

In the above statement, SELECT and UPDATE permissions are granted to the new user and restricted to specific tables. perform these operations on.

In MySQL, you can also use the REVOKE statement to revoke user permissions. The following is an example that shows how to use the REVOKE statement to revoke all user permissions on the database:

REVOKE ALL PRIVILEGES ON database_name.* FROM 'new_username'@'localhost';

In the above statement, use ALL PRIVILEGES to revoke all user permissions on the database. If you only want to revoke the user's permissions on a specific table, you can use the following command:

REVOKE SELECT, UPDATE ON database_name.table_name FROM 'new_username'@'localhost';

The above statement revokes the user's SELECT and UPDATE permissions on the specific table.

Using the GRANT and REVOKE statements, you can easily manage user permissions in the MySQL database. Depending on project requirements, users can be given different permission levels to control their access to and operations on the database.

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