Skip navigation links
MySQL 5.4 Reference Manual :: Privileges Index
SQL Modes Index »
Section Navigation      [Toggle]

Privileges Index

ALL

Section 5.4.1, “Privileges Provided by MySQL”

ALL PRIVILEGES

Section 5.4.1, “Privileges Provided by MySQL”

ALL [PRIVILEGES]

Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

ALTER

Section 12.1.1, “ALTER DATABASE Syntax”
Section 12.1.6, “ALTER TABLE Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.1.26, “RENAME TABLE Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

ALTER ROUTINE

Section 12.1.3, “ALTER FUNCTION Syntax”
Section 12.1.4, “ALTER PROCEDURE Syntax”
Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.21, “DROP PROCEDURE and DROP FUNCTION Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 18.6, “Binary Logging of Stored Programs”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.4, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

CREATE

Section 12.1.6, “ALTER TABLE Syntax”
Section 12.1.8, “CREATE DATABASE Syntax”
Section 12.1.14, “CREATE TABLE Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.1.26, “RENAME TABLE Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE ROUTINE

Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 18.6, “Binary Logging of Stored Programs”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.4, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

CREATE TABLESPACE

Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE TEMPORARY TABLES

Section 12.1.14, “CREATE TABLE Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE USER

Section 12.4.1.1, “CREATE USER Syntax”
Section 12.4.1.2, “DROP USER Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.4.1.4, “RENAME USER Syntax”
Section 12.4.1.5, “REVOKE Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

CREATE VIEW

Section 12.1.7, “ALTER VIEW Syntax”
Section 12.1.16, “CREATE VIEW Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.4, “Restrictions on Views”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

DELETE

Section 12.1.14, “CREATE TABLE Syntax”
Section 12.2.2, “DELETE Syntax”
Section 12.4.3.3, “DROP FUNCTION Syntax”
Section 12.4.1.2, “DROP USER Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.2.7, “REPLACE Syntax”
Section 12.2.10, “TRUNCATE TABLE Syntax”
Section 12.4.3.5, “UNINSTALL PLUGIN Syntax”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 12.4.3.1, “Installing and Uninstalling Plugins”
Section 5.4.1, “Privileges Provided by MySQL”
Section 13.8, “The MERGE Storage Engine”
Section 21.3.2.6, “User-Defined Function Security Precautions”

DROP

Section 12.1.7, “ALTER VIEW Syntax”
Section 12.1.16, “CREATE VIEW Syntax”
Section 12.1.17, “DROP DATABASE Syntax”
Section 12.1.23, “DROP TABLE Syntax”
Section 12.1.25, “DROP VIEW Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.1.26, “RENAME TABLE Syntax”
Section 12.2.10, “TRUNCATE TABLE Syntax”
Section 17.3.1, “Management of RANGE and LIST Partitions”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 5.4, “The MySQL Access Privilege System”

EVENT

Section 12.1.2, “ALTER EVENT Syntax”
Section 12.1.9, “CREATE EVENT Syntax”
Section 12.1.18, “DROP EVENT Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

EXECUTE

Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.21, “DROP PROCEDURE and DROP FUNCTION Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.4, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

FILE

Section 12.4.1.3, “GRANT Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.2.8, “SELECT Syntax”
Section 5.4.7, “Causes of Access-Denied Errors”
Description
Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 16.1.1, “How to Set Up Replication”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 11.4, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”
Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”

GRANT OPTION

Section 12.4.1.3, “GRANT Syntax”
Section 12.4.1.5, “REVOKE Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

INDEX

Section 12.1.6, “ALTER TABLE Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

INSERT

Section 12.1.6, “ALTER TABLE Syntax”
Section 12.4.2.1, “ANALYZE TABLE Syntax”
Section 12.4.3.2, “CREATE FUNCTION Syntax”
Section 12.4.1.1, “CREATE USER Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.2.5, “INSERT Syntax”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 12.1.26, “RENAME TABLE Syntax”
Section 12.4.2.6, “REPAIR TABLE Syntax”
Section 12.2.7, “REPLACE Syntax”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 12.4.3.1, “Installing and Uninstalling Plugins”
Section 13.4.1, “Pluggable Storage Engine Architecture”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 21.3.2.6, “User-Defined Function Security Precautions”

LOCK TABLES

Section 12.4.6.3, “FLUSH Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Description
Section 5.4.1, “Privileges Provided by MySQL”

PROCESS

Section 12.4.1.3, “GRANT Syntax”
Section 12.4.6.4, “KILL Syntax”
Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
Section 5.5.2, “Adding User Accounts”
Section 7.5.6, “Examining Thread Information”
Section 16.1.1, “How to Set Up Replication”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

REFERENCES

Section 12.4.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

RELOAD

Section 12.4.6.3, “FLUSH Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 12.4.6.6, “RESET Syntax”
Section 20.9.3.55, “mysql_refresh()”
Section 20.9.3.56, “mysql_reload()”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Description
Description
Section 11.11.2, “Encryption and Compression Functions”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”

REPLICATION CLIENT

Section 12.4.1.3, “GRANT Syntax”
Section 12.4.5.25, “SHOW MASTER STATUS Syntax”
Section 12.4.5.35, “SHOW SLAVE STATUS Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

REPLICATION SLAVE

Section 12.4.1.3, “GRANT Syntax”
Section 16.1.1.3, “Creating a User for Replication”
Section 16.1.1, “How to Set Up Replication”
Section 5.4.1, “Privileges Provided by MySQL”
Section 16.1.3.3, “Replication Slave Options and Variables”

SELECT

Section 12.4.2.1, “ANALYZE TABLE Syntax”
Section 12.4.2.4, “CHECKSUM TABLE Syntax”
Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.14, “CREATE TABLE Syntax”
Section 12.1.15, “CREATE TRIGGER Syntax”
Section 12.1.16, “CREATE VIEW Syntax”
Section 12.2.2, “DELETE Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.2.5, “INSERT Syntax”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 12.4.2.6, “REPAIR TABLE Syntax”
Section 12.4.5.12, “SHOW CREATE TABLE Syntax”
Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
Section 12.4.5.22, “SHOW GRANTS Syntax”
Section 12.2.11, “UPDATE Syntax”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 20.2.6, “Connector/NET Connection String Options Reference”
Description
Description
Section 5.4.1, “Privileges Provided by MySQL”
Section D.4, “Restrictions on Views”
Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 13.8, “The MERGE Storage Engine”
Section 5.4, “The MySQL Access Privilege System”
Section 18.3.1, “Trigger Syntax”

SHOW DATABASES

Section 12.4.1.3, “GRANT Syntax”
Section 12.4.5.15, “SHOW DATABASES Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

SHOW VIEW

Section 12.4.1.3, “GRANT Syntax”
Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.4, “Restrictions on Views”
Section 19.15, “The INFORMATION_SCHEMA VIEWS Table”

SHUTDOWN

Section 12.4.1.3, “GRANT Syntax”
Section 20.9.3.65, “mysql_shutdown()”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Description
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.11, “The Shutdown Process”

SUPER

Section 12.1.2, “ALTER EVENT Syntax”
Section 12.1.3, “ALTER FUNCTION Syntax”
Section 12.1.5, “ALTER SERVER Syntax”
Section 12.1.7, “ALTER VIEW Syntax”
Section 12.4.6.1, “BINLOG Syntax”
Section 12.1.9, “CREATE EVENT Syntax”
Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.13, “CREATE SERVER Syntax”
Section 12.1.15, “CREATE TRIGGER Syntax”
Section 12.1.16, “CREATE VIEW Syntax”
Section 12.1.18, “DROP EVENT Syntax”
Section 12.1.22, “DROP SERVER Syntax”
Section 12.1.24, “DROP TRIGGER Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.4.6.4, “KILL Syntax”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 12.5.1.3, “SET sql_log_bin Syntax”
Section 12.4.4, “SET Syntax”
Section 12.4.5.25, “SHOW MASTER STATUS Syntax”
Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
Section 12.4.5.35, “SHOW SLAVE STATUS Syntax”
Section 12.4.5.39, “SHOW TRIGGERS Syntax”
Section 12.5.2.7, “START SLAVE Syntax”
Section 12.5.2.8, “STOP SLAVE Syntax”
Section B.5.2.7, “Too many connections”
Section 20.9.3.12, “mysql_dump_debug_info()”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 18.6, “Binary Logging of Stored Programs”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Description
Section 11.11.2, “Encryption and Compression Functions”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 16.1.1, “How to Set Up Replication”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 9.7, “MySQL Server Locale Support”
Section 9.6, “MySQL Server Time Zone Support”
Section 5.4.1, “Privileges Provided by MySQL”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.8, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 5.1.5, “Session System Variables”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 19.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 5.2.4, “The Binary Log”
Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
Section 5.1.6, “Using System Variables”

TRIGGER

Section 12.1.15, “CREATE TRIGGER Syntax”
Section 12.1.24, “DROP TRIGGER Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.4.5.39, “SHOW TRIGGERS Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”

UPDATE

Section 12.1.14, “CREATE TABLE Syntax”
Section 12.1.15, “CREATE TRIGGER Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.2.5, “INSERT Syntax”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.4.1.4, “RENAME USER Syntax”
Section 12.4.1.5, “REVOKE Syntax”
Section 12.2.11, “UPDATE Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 13.8, “The MERGE Storage Engine”
Section 18.3.1, “Trigger Syntax”

USAGE

Section 12.4.1.3, “GRANT Syntax”
Section 5.5.2, “Adding User Accounts”
Section 5.4.1, “Privileges Provided by MySQL”