MySQL Privilege Types
Privilege Type Description
ALL Grants all privileges, except WITH GRANT OPTION
ALTER Grants use of ALTER TABLE
CREATE Grants use of CREATE TABLE
CREATE TEMPORARY TABLES Grants use of CREATE TEMPORARY TABLE
DELETE Grants use of DELETE
DROP Grants use of DROP TABLE
EXECUTE Grants use of stored procedures
FILE Grants use of SELECT INTO OUTFILE and LOAD DATA INFILE
GRANT OPTION Used to revoke WITH GRANT OPTION
INDEX Grants use of CREATE INDEX and DROP INDEX
INSERT Grants use of INSERT
LOCK TABLES Grants use of LOCK TABLES on tables on which the user already has the SELECT privilege
PROCESS Grants use of SHOW FULL PROCESSLIST
RELOAD Grants use of FLUSH
REPLICATION CLIENT Grants ability to ask where the slaves/masters are
REPLICATION SLAVE Grants ability of the replication slaves to read information from master
SELECT Grants use of SELECT
SHOW DATABASES Grants use of SHOW DATABASES
SHUTDOWN Grants use of MYSQLADMIN SHUTDOWN
SUPER Grants the user one connection, one time,
even if the server is at maximum connections limit,
and grants use of CHANGE MASTER, KILL THREAD, MYSQLADMIN DEBUG,
PURGE MASTER LOGS, and SET GLOBAL
UPDATE Grants use of UPDATE
USAGE Grants access to log in to the MySQL Server but bestows no privileges
WITH GRANT OPTION Grants ability for users to grant any privilege they possess to another user
Related examples in the same category