Privilege | Description |
---|---|
ALL | All privileges except GRANT OPTION |
ALTER | Use of ALTER TABLE |
ALTER ROUTINE | Use of ALTER PROCEDURE and DROP PROCEDURE |
CREATE | Use of CREATE TABLE |
CREATE ROUTINE | Use of CREATE PROCEDURE |
CREATE TEMPORARY TABLES | Use of CREATE TEMPORARY TABLE |
CREATE USER | Use of CREATE USER, DROP USER, RENAME USER, andREVOKE ALL PRIVILEGES |
CREATE VIEW | Use of CREATE VIEW |
DELETE | Use of DELETE |
DROP | Use of DROP TABLE |
EXECUTE | Use of CALL and stored procedures |
FILE | Use of SELECT INTO OUTFILE and LOAD DATA INFILE |
GRANT OPTION | Use of GRANT and REVOKE |
INDEX | Use of CREATE INDEX and DROP INDEX |
INSERT | Use of INSERT |
LOCK TABLES | Use of LOCK TABLES |
PROCESS | Use of SHOW FULL PROCESSLIST |
RELOAD | Use of FLUSH |
REPLICATION CLIENT | Access to location of servers |
REPLICATION SLAVE | Used by replication slaves |
SELECT | Use of SELECT |
SHOW DATABASES | Use of SHOW DATABASES |
SHOW VIEW | Use of SHOW CREATE VIEW |
SHUTDOWN | Use of mysqladmin shutdown (used to shut down MySQL) |
SUPER | Use of CHANGE MASTER, KILL, LOGS, PURGE MASTER, and SET GLOBAL. Also allows mysqladmin debuglogin. |
UPDATE | Use of UPDATE |
USAGE | No access |
mysql 的权限解释
最新推荐文章于 2024-04-24 12:53:17 发布