账号权限

账号类型

权限

高权限账号

SELECT、INSERT、UPDATE、DELETE、CREATE

DROP、RELOAD、PROCESS、REFERENCES、INDEX

ALTER、LOCK TABLES、EXECUTE、TRIGGER、CREATE TEMPORARY TABLES

REPLICATION SLAVE、REPLICATION CLIENT、CREATE VIEW、SHOW VIEW

CREATE ROUTINE、ALTER ROUTINE、CREATE USER、EVENT

权限类型

权限

读写

SELECT、INSERT、UPDATE、DELETE、CREATE、EXECUTE

DROP、REFERENCES、INDEX、ALTER、CREATE TEMPORARY TABLES

EVENT、CREATE VIEW、SHOW VIEW、CREATE ROUTINE、ALTER ROUTINE

LOCK TABLES、TRIGGER、PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

只读

SELECT、LOCK TABLES、SHOW VIEW

PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

仅DML

SELECT、INSERT、UPDATE、DELETE、LOCK TABLES

CREATE TEMPORARY TABLES、EXECUTE、TRIGGER、EVENT

SHOW VIEW、PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

仅DDL

CREATE、DROP、INDEX、ALTER、CREATE TEMPORARY TABLES

CREATE VIEW、SHOW VIEW、CREATE ROUTINE、ALTER ROUTINE

LOCK TABLES、PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

只读+索引

SELECT、INDEX、LOCK TABLES、SHOW VIEW

PROCESS、REPLICATION SLAVE、REPLICATION CLIENT