Privileges Index

A | C | D | E | F | G | I | L | P | R | S | T | U

A

[index top]

ALL

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”

ALL PRIVILEGES

Section 6.2.1, “Privileges Provided by MySQL”

ALTER

Section 13.1.1, “ALTER DATABASE Syntax”
Section 13.1.7, “ALTER TABLE Syntax”
Section 19.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Syntax”

ALTER ROUTINE

Section 13.1.3, “ALTER FUNCTION Syntax”
Section 13.1.5, “ALTER PROCEDURE Syntax”
Section 17.1.4.4, “Binary Log Options and Variables”
Section 20.7, “Binary Logging of Stored Programs”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.26, “DROP PROCEDURE and DROP FUNCTION Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 20.2.2, “Stored Routines and MySQL Privileges”

C

[index top]

CREATE

Section 13.1.7, “ALTER TABLE Syntax”
Section 13.1.10, “CREATE DATABASE Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 19.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Syntax”

CREATE ROUTINE

Section 17.1.4.4, “Binary Log Options and Variables”
Section 20.7, “Binary Logging of Stored Programs”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section A.4, “MySQL 5.6 FAQ: Stored Procedures and Functions”
Section 6.2.1, “Privileges Provided by MySQL”
Section 20.2.2, “Stored Routines and MySQL Privileges”

CREATE TABLESPACE

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”

CREATE TEMPORARY TABLES

Section 13.1.17.3, “CREATE TEMPORARY TABLE Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”

CREATE USER

Section 6.3.2, “Adding User Accounts”
Section 13.7.1.1, “ALTER USER Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 13.7.1.2, “CREATE USER Syntax”
Section 13.7.1.3, “DROP USER Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.1.5, “RENAME USER Syntax”
Section 13.7.1.6, “REVOKE Syntax”

CREATE VIEW

Section 13.1.9, “ALTER VIEW Syntax”
Section 13.1.20, “CREATE VIEW Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section C.5, “Restrictions on Views”

D

[index top]

DELETE

Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 13.1.17, “CREATE TABLE Syntax”
Section 13.2.2, “DELETE Syntax”
Section 13.7.3.2, “DROP FUNCTION Syntax”
Section 13.7.1.3, “DROP USER Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 5.6.1, “Installing and Uninstalling User-Defined Functions”
Section 18.5.11.2, “NDB Cluster and MySQL Privileges”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.2.8, “REPLACE Syntax”
Section 15.7, “The MERGE Storage Engine”
Section 22.12.2.4, “The setup_objects Table”
Section 24.4.2.5, “UDF Compiling and Installing”
Section 24.4.2.6, “UDF Security Precautions”
Section 13.7.3.4, “UNINSTALL PLUGIN Syntax”
Section 13.1.17.6, “Using FOREIGN KEY Constraints”

DROP

Section 13.1.7, “ALTER TABLE Syntax”
Section 13.1.9, “ALTER VIEW Syntax”
Section 13.1.20, “CREATE VIEW Syntax”
Section 8.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section 13.1.21, “DROP DATABASE Syntax”
Section 13.1.28, “DROP TABLE Syntax”
Section 13.1.31, “DROP VIEW Syntax”
Section 19.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.4, “GRANT Syntax”
Section 19.3.1, “Management of RANGE and LIST Partitions”
Section 12.18.1, “MySQL Enterprise Encryption Installation”
Section 22.11, “Performance Schema General Table Characteristics”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Syntax”
Section 22.12.10.1, “The host_cache Table”
Section 6.2, “The MySQL Access Privilege System”
Section 13.1.33, “TRUNCATE TABLE Syntax”

E

[index top]

EVENT

Section 13.1.2, “ALTER EVENT Syntax”
Section 13.1.11, “CREATE EVENT Syntax”
Section 13.1.22, “DROP EVENT Syntax”
Section 20.4.1, “Event Scheduler Overview”
Section 20.4.3, “Event Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.5.9, “SHOW CREATE EVENT Syntax”
Section 13.7.5.19, “SHOW EVENTS Syntax”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”

EXECUTE

Section 20.6, “Access Control for Stored Programs and Views”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.26, “DROP PROCEDURE and DROP FUNCTION Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 20.2.2, “Stored Routines and MySQL Privileges”

F

[index top]

FILE

Section 13.1.17, “CREATE TABLE Syntax”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.2, “Grant Tables”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.7, “LOAD XML Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 12.18.2, “MySQL Enterprise Encryption Usage and Examples”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 5.1.7, “Server System Variables”
Section 12.5, “String Functions”
Section 11.4.3, “The BLOB and TEXT Types”
Section 6.2.7, “Troubleshooting Problems Connecting to MySQL”

G

[index top]

GRANT OPTION

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.1.6, “REVOKE Syntax”
Section 21.6, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 21.21, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
Section 21.26, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 21.28, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

I

[index top]

INDEX

Section 13.1.7, “ALTER TABLE Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”

INSERT

Section 20.6, “Access Control for Stored Programs and Views”
Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 13.1.7, “ALTER TABLE Syntax”
Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.1.2, “CREATE USER Syntax”
Section 13.1.20, “CREATE VIEW Syntax”
Section 19.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.4, “GRANT Syntax”
Section 13.2.5, “INSERT Syntax”
Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 5.6.1, “Installing and Uninstalling User-Defined Functions”
Section 12.18.1, “MySQL Enterprise Encryption Installation”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 15.11.1, “Pluggable Storage Engine Architecture”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Syntax”
Section 13.7.2.5, “REPAIR TABLE Syntax”
Section 13.2.8, “REPLACE Syntax”
Section 5.1.6, “Server Command Options”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”
Section 22.12.2.4, “The setup_objects Table”
Section 24.4.2.5, “UDF Compiling and Installing”
Section 24.4.2.6, “UDF Security Precautions”
Section 13.1.17.6, “Using FOREIGN KEY Constraints”

L

[index top]

LOCK TABLES

Section 13.7.6.3, “FLUSH Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.10, “mysqlhotcopy — A Database Backup Program”
Section 6.2.1, “Privileges Provided by MySQL”

P

[index top]

PROCESS

Section 6.3.2, “Adding User Accounts”
Section 14.17.2, “Enabling InnoDB Monitors”
Section 20.4.2, “Event Scheduler Configuration”
Section 8.14, “Examining Thread Information”
Section 13.7.1.4, “GRANT Syntax”
Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 21.1, “Introduction”
Section 13.7.6.4, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 18.5.4, “MySQL Server Usage for NDB Cluster”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 13.7.5.30, “SHOW PROCESSLIST Syntax”
Section 21.30.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 21.30.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 21.30.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 21.30.4, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 21.30.6, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 21.30.5, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 21.30.7, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 21.30.8, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 21.30.9, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 21.30.10, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 21.30.11, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 21.30.12, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 21.30.14, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 21.30.13, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 21.30.15, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 21.30.16, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 21.30.17, “The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table”
Section 21.30.18, “The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table”
Section 21.30.19, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table”
Section 21.30.20, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table”
Section 21.30.21, “The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table”
Section 21.30.22, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 21.30.23, “The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table”
Section 21.30.24, “The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View”
Section 21.30.25, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 21.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 22.12.10.3, “The threads Table”
Section B.5.2.7, “Too many connections”

PROXY

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.2, “Grant Tables”
Section 24.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 6.5.1.6, “PAM Pluggable Authentication”
Section 6.2.1, “Privileges Provided by MySQL”
Section 6.3.8, “Proxy Users”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 22.12.10.1, “The host_cache Table”
Section 6.5.1.7, “Windows Pluggable Authentication”

PROXY ... WITH GRANT OPTION

Section 6.3.8, “Proxy Users”

R

[index top]

REFERENCES

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.1.17.6, “Using FOREIGN KEY Constraints”

RELOAD

Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 6.3.2, “Adding User Accounts”
Section 8.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section 12.13, “Encryption and Compression Functions”
Section 13.7.6.3, “FLUSH Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.2, “Grant Tables”
Section 23.8.7.56, “mysql_refresh()”
Section 23.8.7.57, “mysql_reload()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.10, “mysqlhotcopy — A Database Backup Program”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.6.6, “RESET Syntax”
Section 22.12.10.1, “The host_cache Table”

REPLICATION CLIENT

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.5.2, “SHOW BINARY LOGS Syntax”
Section 13.7.5.24, “SHOW MASTER STATUS Syntax”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”

REPLICATION SLAVE

Section 17.1.1.3, “Creating a User for Replication”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 17.3.8, “Setting Up Replication to Use Encrypted Connections”

S

[index top]

SELECT

Section 20.6, “Access Control for Stored Programs and Views”
Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 13.7.2.3, “CHECKSUM TABLE Syntax”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.17.4, “CREATE TABLE ... LIKE Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 13.1.19, “CREATE TRIGGER Syntax”
Section 13.1.20, “CREATE VIEW Syntax”
Section 13.2.2, “DELETE Syntax”
Section 13.8.2, “EXPLAIN Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 13.2.5, “INSERT Syntax”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.10, “mysqlhotcopy — A Database Backup Program”
Section 18.5.11.2, “NDB Cluster and MySQL Privileges”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 22.11, “Performance Schema General Table Characteristics”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.2.5, “REPAIR TABLE Syntax”
Section C.5, “Restrictions on Views”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 13.7.5.22, “SHOW GRANTS Syntax”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”
Section 15.7, “The MERGE Storage Engine”
Section 6.2, “The MySQL Access Privilege System”
Section 20.3.1, “Trigger Syntax and Examples”
Section 13.2.11, “UPDATE Syntax”
Section 13.1.17.6, “Using FOREIGN KEY Constraints”

SHOW DATABASES

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 13.7.5.15, “SHOW DATABASES Syntax”

SHOW VIEW

Section 13.8.2, “EXPLAIN Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.1, “Privileges Provided by MySQL”
Section C.5, “Restrictions on Views”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”

SHUTDOWN

Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.2, “Grant Tables”
Section 23.8.7.66, “mysql_shutdown()”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 6.2.1, “Privileges Provided by MySQL”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 5.1.15, “The Server Shutdown Process”

SUPER

Section 20.6, “Access Control for Stored Programs and Views”
Section 13.7.1, “Account Management Statements”
Section 13.1.3, “ALTER FUNCTION Syntax”
Section 13.1.6, “ALTER SERVER Syntax”
Section 13.7.1.1, “ALTER USER Syntax”
Section 13.1.9, “ALTER VIEW Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 17.1.4.4, “Binary Log Options and Variables”
Section 20.7, “Binary Logging of Stored Programs”
Section 13.7.6.1, “BINLOG Syntax”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 10.5, “Configuring Application Character Set and Collation”
Section 13.1.11, “CREATE EVENT Syntax”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.16, “CREATE SERVER Syntax”
Section 13.1.19, “CREATE TRIGGER Syntax”
Section 13.7.1.2, “CREATE USER Syntax”
Section 13.1.20, “CREATE VIEW Syntax”
Section 13.1.27, “DROP SERVER Syntax”
Section 13.7.1.3, “DROP USER Syntax”
Section 12.13, “Encryption and Compression Functions”
Section 13.7.1.4, “GRANT Syntax”
Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 17.1.1, “How to Set Up Replication”
Section 13.7.6.4, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section A.4, “MySQL 5.6 FAQ: Stored Procedures and Functions”
Section 5.1.12, “MySQL Server Time Zone Support”
Section 23.8.7.12, “mysql_dump_debug_info()”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.1.5, “RENAME USER Syntax”
Section 13.7.1.6, “REVOKE Syntax”
Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Syntax”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 13.7.5.2, “SHOW BINARY LOGS Syntax”
Section 13.7.5.22, “SHOW GRANTS Syntax”
Section 13.7.5.24, “SHOW MASTER STATUS Syntax”
Section 13.7.5.30, “SHOW PROCESSLIST Syntax”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 13.4.2.5, “START SLAVE Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 13.4.2.6, “STOP SLAVE Syntax”
Section 5.1.8.1, “System Variable Privileges”
Section B.5.2.7, “Too many connections”

T

[index top]

TRIGGER

Section 20.6, “Access Control for Stored Programs and Views”
Section 13.1.19, “CREATE TRIGGER Syntax”
Section 13.1.30, “DROP TRIGGER Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.5.13, “SHOW CREATE TRIGGER Syntax”
Section 13.7.5.39, “SHOW TRIGGERS Syntax”
Section 21.27, “The INFORMATION_SCHEMA TRIGGERS Table”

U

[index top]

UPDATE

Section 20.6, “Access Control for Stored Programs and Views”
Section 13.7.1.1, “ALTER USER Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 13.1.17, “CREATE TABLE Syntax”
Section 13.1.19, “CREATE TRIGGER Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 13.2.5, “INSERT Syntax”
Section 18.5.11.2, “NDB Cluster and MySQL Privileges”
Section 22.11, “Performance Schema General Table Characteristics”
Section 22.4, “Performance Schema Runtime Configuration”
Section 22.12.2, “Performance Schema Setup Tables”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.1.5, “RENAME USER Syntax”
Section 13.7.1.6, “REVOKE Syntax”
Section 15.7, “The MERGE Storage Engine”
Section 22.12.2.4, “The setup_objects Table”
Section 20.3.1, “Trigger Syntax and Examples”
Section 13.2.11, “UPDATE Syntax”
Section 13.1.17.6, “Using FOREIGN KEY Constraints”

USAGE

Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”