Privileges Index

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

A

[index top]

ALL

Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

ALL PRIVILEGES

Section 6.2.2, “Privileges Provided by MySQL”

ALTER

Section 13.1.1, “ALTER DATABASE Statement”
Section 13.1.7, “ALTER TABLE Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Statement”

ALTER ROUTINE

Section 13.1.3, “ALTER FUNCTION Statement”
Section 13.1.5, “ALTER PROCEDURE Statement”
Section 17.1.3.4, “Binary Log Options and Variables”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.26, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 20.7, “Stored Program Binary Logging”
Section 20.2.2, “Stored Routines and MySQL Privileges”

C

[index top]

CREATE

Section 13.1.7, “ALTER TABLE Statement”
Section 13.1.10, “CREATE DATABASE Statement”
Section 13.1.17, “CREATE TABLE Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Statement”

CREATE ROUTINE

Section 17.1.3.4, “Binary Log Options and Variables”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.7.1.3, “GRANT Statement”
Section A.4, “MySQL 5.5 FAQ: Stored Procedures and Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 20.7, “Stored Program Binary Logging”
Section 20.2.2, “Stored Routines and MySQL Privileges”

CREATE TABLESPACE

Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

CREATE TEMPORARY TABLES

Section 13.1.17.3, “CREATE TEMPORARY TABLE Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

CREATE USER

Section 6.2.7, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 6.2.9, “Assigning Account Passwords”
Section 13.7.1.1, “CREATE USER Statement”
Section 13.7.1.2, “DROP USER Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.4, “RENAME USER Statement”
Section 13.7.1.5, “REVOKE Statement”

CREATE VIEW

Section 13.1.9, “ALTER VIEW Statement”
Section 13.1.20, “CREATE VIEW Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 20.9, “Restrictions on Views”

D

[index top]

DELETE

Section 6.2.6, “Access Control, Stage 2: Request Verification”
Section 24.4.2, “Adding a User-Defined Function”
Section 13.1.17, “CREATE TABLE Statement”
Section 13.2.2, “DELETE Statement”
Section 13.7.3.2, “DROP FUNCTION Statement”
Section 13.7.1.2, “DROP USER Statement”
Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 13.7.1.3, “GRANT Statement”
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.2, “Privileges Provided by MySQL”
Section 13.2.8, “REPLACE Statement”
Section 15.8, “The MERGE Storage Engine”
Section 13.7.3.4, “UNINSTALL PLUGIN Statement”

DROP

Section 6.2, “Access Control and Account Management”
Section 13.1.7, “ALTER TABLE Statement”
Section 13.1.9, “ALTER VIEW Statement”
Section 13.1.20, “CREATE VIEW Statement”
Section 13.1.21, “DROP DATABASE Statement”
Section 13.1.28, “DROP TABLE Statement”
Section 13.1.31, “DROP VIEW Statement”
Section 13.7.1.3, “GRANT Statement”
Section 19.3.1, “Management of RANGE and LIST Partitions”
Section 22.9, “Performance Schema General Table Characteristics”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Statement”
Section 13.1.33, “TRUNCATE TABLE Statement”

E

[index top]

EVENT

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

EXECUTE

Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.26, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 20.6, “Stored Object Access Control”
Section 20.2.2, “Stored Routines and MySQL Privileges”

F

[index top]

FILE

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

G

[index top]

GRANT OPTION

Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.5, “REVOKE Statement”
Section 21.6, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 21.20, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
Section 21.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 21.27, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

I

[index top]

INDEX

Section 13.1.7, “ALTER TABLE Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

INSERT

Section 6.2.6, “Access Control, Stage 2: Request Verification”
Section 24.4.2, “Adding a User-Defined Function”
Section 13.1.7, “ALTER TABLE Statement”
Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 6.2.9, “Assigning Account Passwords”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.1.1, “CREATE USER Statement”
Section 13.1.20, “CREATE VIEW Statement”
Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 13.7.1.3, “GRANT Statement”
Section 13.2.5, “INSERT Statement”
Section 13.7.3.3, “INSTALL PLUGIN Statement”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 5.6.1, “Installing and Uninstalling User-Defined Functions”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 15.2.1, “Pluggable Storage Engine Architecture”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.32, “RENAME TABLE Statement”
Section 13.7.2.5, “REPAIR TABLE Statement”
Section 13.2.8, “REPLACE Statement”
Section 5.1.6, “Server Command Options”
Section 20.6, “Stored Object Access Control”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”

L

[index top]

LOCK TABLES

Section 13.7.6.3, “FLUSH Statement”
Section 13.7.1.3, “GRANT Statement”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”

P

[index top]

PROCESS

Section 6.2.7, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 14.20.2, “Enabling InnoDB Monitors”
Section 20.4.2, “Event Scheduler Configuration”
Section 8.14, “Examining Thread Information”
Section 13.7.1.3, “GRANT Statement”
Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 21.1, “Introduction”
Section 13.7.6.4, “KILL Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 18.5.4, “MySQL Server Usage for NDB Cluster”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.5.16, “SHOW ENGINE Statement”
Section 13.7.5.30, “SHOW PROCESSLIST Statement”
Section 21.29.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 21.29.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 21.29.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 21.29.4, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 21.29.5, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 21.29.7, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 21.29.6, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 21.29.8, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 21.15, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 22.10.6.2, “The threads Table”
Section B.4.2.7, “Too many connections”

PROXY

Section 13.7.1.3, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 24.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 6.4.1.4, “PAM Pluggable Authentication”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.2.11, “Proxy Users”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 6.4.1.5, “Windows Pluggable Authentication”

PROXY ... WITH GRANT OPTION

Section 6.2.11, “Proxy Users”

R

[index top]

REFERENCES

Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

RELOAD

Section 6.2.6, “Access Control, Stage 2: Request Verification”
Section 6.2.7, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 12.13, “Encryption and Compression Functions”
Section 13.7.6.3, “FLUSH Statement”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 23.7.6.55, “mysql_refresh()”
Section 23.7.6.56, “mysql_reload()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.6.6, “RESET Statement”

REPLICATION CLIENT

Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.5.2, “SHOW BINARY LOGS Statement”
Section 13.7.5.24, “SHOW MASTER STATUS Statement”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”

REPLICATION SLAVE

Section 17.1.1.3, “Creating a User for Replication”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3.7, “Setting Up Replication to Use Encrypted Connections”

S

[index top]

SELECT

Section 6.2, “Access Control and Account Management”
Section 6.2.6, “Access Control, Stage 2: Request Verification”
Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 13.7.2.3, “CHECKSUM TABLE Statement”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.17.4, “CREATE TABLE ... LIKE Statement”
Section 13.1.17, “CREATE TABLE Statement”
Section 13.1.19, “CREATE TRIGGER Statement”
Section 13.1.20, “CREATE VIEW Statement”
Section 13.2.2, “DELETE Statement”
Section 13.8.2, “EXPLAIN Statement”
Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 13.7.1.3, “GRANT Statement”
Section 13.2.5, “INSERT Statement”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 18.5.11.2, “NDB Cluster and MySQL Privileges”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 22.9, “Performance Schema General Table Characteristics”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.2.5, “REPAIR TABLE Statement”
Section 20.9, “Restrictions on Views”
Section 13.7.5.14, “SHOW CREATE VIEW Statement”
Section 13.7.5.22, “SHOW GRANTS Statement”
Section 20.6, “Stored Object Access Control”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”
Section 15.8, “The MERGE Storage Engine”
Section 20.3.1, “Trigger Syntax and Examples”
Section 13.2.11, “UPDATE Statement”

SHOW DATABASES

Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 13.7.5.15, “SHOW DATABASES Statement”

SHOW VIEW

Section 13.8.2, “EXPLAIN Statement”
Section 13.7.1.3, “GRANT Statement”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 20.9, “Restrictions on Views”
Section 13.7.5.14, “SHOW CREATE VIEW Statement”
Section 21.28, “The INFORMATION_SCHEMA VIEWS Table”

SHUTDOWN

Section 6.2.6, “Access Control, Stage 2: Request Verification”
Section 13.7.1.3, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 23.7.6.65, “mysql_shutdown()”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.15, “The Server Shutdown Process”

SUPER

Section 13.7.1, “Account Management Statements”
Section 13.1.3, “ALTER FUNCTION Statement”
Section 13.1.6, “ALTER SERVER Statement”
Section 13.1.9, “ALTER VIEW Statement”
Section 6.2.9, “Assigning Account Passwords”
Section 17.1.3.4, “Binary Log Options and Variables”
Section 13.7.6.1, “BINLOG Statement”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 10.5, “Configuring Application Character Set and Collation”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.16, “CREATE SERVER Statement”
Section 13.1.19, “CREATE TRIGGER Statement”
Section 13.7.1.1, “CREATE USER Statement”
Section 13.1.27, “DROP SERVER Statement”
Section 13.7.1.2, “DROP USER Statement”
Section 12.13, “Encryption and Compression Functions”
Section 13.7.1.3, “GRANT Statement”
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 Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section A.4, “MySQL 5.5 FAQ: Stored Procedures and Functions”
Section 5.1.12, “MySQL Server Time Zone Support”
Section 23.7.6.12, “mysql_dump_debug_info()”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.4, “RENAME USER Statement”
Section 13.7.1.5, “REVOKE Statement”
Section 17.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 13.7.1.6, “SET PASSWORD Statement”
Section 13.3.6, “SET TRANSACTION Statement”
Section 13.7.5.2, “SHOW BINARY LOGS Statement”
Section 13.7.5.22, “SHOW GRANTS Statement”
Section 13.7.5.24, “SHOW MASTER STATUS Statement”
Section 13.7.5.30, “SHOW PROCESSLIST Statement”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”
Section 13.4.2.5, “START SLAVE Statement”
Section 13.4.2.6, “STOP SLAVE Statement”
Section 20.6, “Stored Object Access Control”
Section 20.7, “Stored Program Binary Logging”
Section 5.1.8.1, “System Variable Privileges”
Section B.4.2.7, “Too many connections”

T

[index top]

TRIGGER

Section 13.1.19, “CREATE TRIGGER Statement”
Section 13.1.30, “DROP TRIGGER Statement”
Section 13.7.1.3, “GRANT Statement”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.5.13, “SHOW CREATE TRIGGER Statement”
Section 13.7.5.39, “SHOW TRIGGERS Statement”
Section 21.26, “The INFORMATION_SCHEMA TRIGGERS Table”

U

[index top]

UPDATE

Section 6.2.9, “Assigning Account Passwords”
Section 13.1.17, “CREATE TABLE Statement”
Section 13.1.19, “CREATE TRIGGER Statement”
Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 13.7.1.3, “GRANT Statement”
Section 13.2.5, “INSERT Statement”
Section 18.5.11.2, “NDB Cluster and MySQL Privileges”
Section 22.9, “Performance Schema General Table Characteristics”
Section 22.4, “Performance Schema Runtime Configuration”
Section 22.10.2, “Performance Schema Setup Tables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.4, “RENAME USER Statement”
Section 13.7.1.5, “REVOKE Statement”
Section 20.6, “Stored Object Access Control”
Section 15.8, “The MERGE Storage Engine”
Section 20.3.1, “Trigger Syntax and Examples”
Section 13.2.11, “UPDATE Statement”

USAGE

Section 13.7.1.3, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”