"ALL [PRIVILEGES]"包括哪些内容？

Question

当我授予"所有权限"时，会获得哪些权限?

-> ALL [PRIVILEGES] Grant all privileges at specified access level except GRANT OPTION

是否包含"FILE"-privilege?

Answer 1

All指除GRANT以外的所有，即

CREATE
DROP
LOCK TABLES
REFERENCES
EVENT
ALTER
DELETE
INDEX
INSERT
SELECT
UPDATE
CREATE TEMPORARY TABLES
TRIGGER
CREATE VIEW
SHOW VIEW
ALTER ROUTINE
CREATE ROUTINE
EXECUTE
FILE
CREATE TABLESPACE
CREATE USER
PROCESS
PROXY
RELOAD
REPLICATION CLIENT
REPLICATION SLAVE
SHOW DATABASES
SHUTDOWN
SUPER