Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the permission names of MySQL". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the permission names of MySQL"?

ALL [PRIVILEGES]

Set all simple permissions except GRANT OPTION

ALTER

Allow use of ALTER TABLE

ALTER ROUTINE

Change or cancel stored subroutines

CREATE

Allow use of CREATE TABLE

CREATE ROUTINE

Allow the creation of stored subroutines

CREATE TEMPORARY TABLES

Allow use of CREATE TEMPORARY TABLE

CREATE USER

Allow CREATE USER, DROP USER, RENAME USER and REVOKE ALL PRIVILEGES

CREATE VIEW

Allow use of CREATE VIEW

DELETE

Allow use of DELETE

DROP

Allow use of DROP TABLE

EXECUTE

Allow users to run stored subroutines

FILE

Allow use of SELECT...INTO OUTFILE and LOAD DATA INFILE

INDEX

Allow use of CREATE INDEX and DROP INDE

INSERT

Allow use of INSERT

LOCK TABLES

Allow LOCK TABLES to be used on tables where user has SELECT permission

PROCESS

Allow use of SHOW FULL PROCESSLIST

RELOAD

Allow use of FLUSH

REPLICATION CLIENT

Allows the user to ask for the address of the secondary server or the primary server

REPLICATION SLAVE

For replicated secondary servers (reading binary log events from the master server)

SELECT

Allow use of SELECT

SHOW DATABASES

Allow all databases to be displayed using SHOW DATABASES

SHOW VIEW

Allow use of SHOW CREATE VIEW

SHUTDOWN

Allow use of mysqladmin shutdown

SUPER

Allows the use of CHANGE MASTER, KILL, PURGE MASTER LOGS and SET GLOBAL statements, mysqladmin debug commands; allows you to connect (once), even if max_connections has been reached

UPDATE

Allow use of UPDATE

GRANT OPTION

Allow permission to be granted

Thank you for your reading, the above is the content of "what is the permission name of MySQL?" after the study of this article, I believe you have a deeper understanding of what the permission name of MySQL has, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.