Privileges Index

Privileges Index
Prev		Next

Privileges Index

A | B | C | D | E | F | G | I | L | N | P | R | S | T | U | V | X

A

ALL

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

ALL PRIVILEGES

Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.21, “SHOW GRANTS Statement”

ALTER

Section 13.1.2, “ALTER DATABASE Statement”
Section 13.1.9, “ALTER TABLE Statement”
Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Statement”

ALTER ROUTINE

Section 13.1.4, “ALTER FUNCTION Statement”
Section 13.1.7, “ALTER PROCEDURE Statement”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 25.7, “Stored Program Binary Logging”
Section 25.2.2, “Stored Routines and MySQL Privileges”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”

APPLICATION_PASSWORD_ADMIN

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.15, “Password Management”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.10, “SET PASSWORD Statement”

AUDIT_ADMIN

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.1, “Elements of MySQL Enterprise Audit”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

B

BACKUP_ADMIN

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.2, “Cloning Data Locally”
Section 18.4.3.2, “Cloning for Distributed Recovery”
Section 5.6.7.3, “Cloning Remote Data”
Section 13.7.1.6, “GRANT Statement”
Section 13.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 6.2.2, “Privileges Provided by MySQL”
Section 18.2.1.3, “User Credentials For Distributed Recovery”
Section 1.3, “What Is New in MySQL 8.0”

BINLOG_ADMIN

Section 13.7.8.1, “BINLOG Statement”
Section 13.7.1.6, “GRANT Statement”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.4.1.1, “PURGE BINARY LOGS Statement”

BINLOG_ENCRYPTION_ADMIN

Section 13.1.5, “ALTER INSTANCE Statement”
Section 17.3.2.3, “Binary Log Master Key Rotation”
Section 17.3.2, “Encrypting Binary Log Files and Relay Log Files”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

C

CLONE_ADMIN

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.3, “Cloning Remote Data”
Section 13.7.1.6, “GRANT Statement”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 6.2.2, “Privileges Provided by MySQL”

CONNECTION_ADMIN

Section 6.2.11, “Account Categories”
Section 13.7.1, “Account Management Statements”
Section 5.1.12.2, “Administrative Connection Management”
Section 13.1.5, “ALTER INSTANCE Statement”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.14, “Assigning Account Passwords”
Section 10.5, “Configuring Application Character Set and Collation”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 5.1.12.1, “Connection Interfaces”
Section 13.7.1.2, “CREATE ROLE Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 13.7.1.4, “DROP ROLE Statement”
Section 13.7.1.5, “DROP USER Statement”
Section 18.6.6.4, “Exit Action”
Section 13.7.1.6, “GRANT Statement”
Section 18.8, “Group Replication System Variables”
Section 13.7.8.4, “KILL Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Statement”
Section 13.7.1.8, “REVOKE Statement”
Section 5.1.8, “Server System Variables”
Section 13.7.1.10, “SET PASSWORD Statement”
Section 13.3.7, “SET TRANSACTION Statement”
Section 13.7.7.29, “SHOW PROCESSLIST Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section B.3.2.5, “Too many connections”

CREATE

Section 13.1.9, “ALTER TABLE Statement”
Section 13.1.12, “CREATE DATABASE Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Statement”
Section 13.2.5, “IMPORT TABLE Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Statement”

CREATE ROLE

Section 13.7.1.2, “CREATE ROLE Statement”
Section 13.7.1.6, “GRANT Statement”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.2.10, “Using Roles”

CREATE ROUTINE

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.7.1.6, “GRANT Statement”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 25.7, “Stored Program Binary Logging”
Section 25.2.2, “Stored Routines and MySQL Privileges”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”

CREATE TABLESPACE

Section 13.1.10, “ALTER TABLESPACE Statement”
Section 15.6.3.3, “General Tablespaces”
Section 13.7.1.6, “GRANT Statement”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 6.2.2, “Privileges Provided by MySQL”

CREATE TEMPORARY TABLES

Section 13.1.20.2, “CREATE TEMPORARY TABLE Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

CREATE USER

Section 6.2.11, “Account Categories”
Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.14, “Assigning Account Passwords”
Section 13.7.1.2, “CREATE ROLE Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 13.7.1.4, “DROP ROLE Statement”
Section 13.7.1.5, “DROP USER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.15, “Password Management”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Statement”
Section 13.7.1.8, “REVOKE Statement”
Section 13.7.1.9, “SET DEFAULT ROLE Statement”
Section 13.7.1.10, “SET PASSWORD Statement”
Section 26.46, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 6.2.10, “Using Roles”

CREATE VIEW

Section 13.1.11, “ALTER VIEW Statement”
Section 13.1.23, “CREATE VIEW Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 25.9, “Restrictions on Views”

D

DELETE

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.2.2, “DELETE Statement”
Section 13.7.4.2, “DROP FUNCTION Statement for User-Defined Functions”
Section 13.7.1.5, “DROP USER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.7.1, “Installing and Uninstalling User-Defined Functions”
Section 15.7.2.4, “Locking Reads”
Section 23.5.17.2, “NDB Cluster and MySQL Privileges”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.2.9, “REPLACE Statement”
Section 16.7, “The MERGE Storage Engine”
Section 27.12.2.4, “The setup_objects Table”
Section 13.7.4.5, “UNINSTALL COMPONENT Statement”
Section 13.7.4.6, “UNINSTALL PLUGIN Statement”
Section 6.2.10, “Using Roles”

DROP

Section 6.2, “Access Control and Account Management”
Section 13.1.9, “ALTER TABLE Statement”
Section 13.1.11, “ALTER VIEW Statement”
Section 13.1.23, “CREATE VIEW Statement”
Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 13.1.24, “DROP DATABASE Statement”
Section 13.1.32, “DROP TABLE Statement”
Section 13.1.35, “DROP VIEW Statement”
Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 24.3.1, “Management of RANGE and LIST Partitions”
Section 6.6.1, “MySQL Enterprise Encryption Installation”
Section 27.11, “Performance Schema General Table Characteristics”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Statement”
Section 27.12.19.5, “The host_cache Table”
Section 13.1.37, “TRUNCATE TABLE Statement”
Section 1.3, “What Is New in MySQL 8.0”

DROP ROLE

Section 13.7.1.4, “DROP ROLE Statement”
Section 13.7.1.6, “GRANT Statement”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.2.10, “Using Roles”

E

ENCRYPTION_KEY_ADMIN

Section 13.1.5, “ALTER INSTANCE Statement”
Section 13.7.1.6, “GRANT Statement”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.9, “Migrating Keys Between Keyring Keystores”
Section 6.2.2, “Privileges Provided by MySQL”

EVENT

Section 13.1.3, “ALTER EVENT Statement”
Section 13.1.13, “CREATE EVENT Statement”
Section 13.1.25, “DROP EVENT Statement”
Section 25.4.1, “Event Scheduler Overview”
Section 25.4.3, “Event Syntax”
Section 13.7.1.6, “GRANT Statement”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.7, “SHOW CREATE EVENT Statement”
Section 13.7.7.18, “SHOW EVENTS Statement”
Section 25.4.6, “The Event Scheduler and MySQL Privileges”

EXECUTE

Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 6.4.4.10, “General-Purpose Keyring Key-Management Functions”
Section 13.7.1.6, “GRANT Statement”
Section 5.6.7.9, “Monitoring Cloning Operations”
Section 28.1, “Prerequisites for Using the sys Schema”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 25.6, “Stored Object Access Control”
Section 25.2.2, “Stored Routines and MySQL Privileges”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”

F

FILE

Section 13.1.20, “CREATE TABLE Statement”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 13.2.5, “IMPORT TABLE Statement”
Section 13.2.7, “LOAD DATA Statement”
Section 13.2.8, “LOAD XML Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.5.1.19, “Replication and LOAD DATA”
Section 13.2.10.1, “SELECT ... INTO Statement”
Section 5.1.8, “Server System Variables”
Section 12.8, “String Functions and Operators”
Section 11.3.4, “The BLOB and TEXT Types”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 1.3, “What Is New in MySQL 8.0”

FIREWALL_ADMIN

Section 6.4.7.1, “Elements of MySQL Enterprise Firewall”
Section 13.7.1.6, “GRANT Statement”
Section 6.4.7.4, “MySQL Enterprise Firewall Reference”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”

FIREWALL_USER

Section 6.4.7.1, “Elements of MySQL Enterprise Firewall”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”

FLUSH_OPTIMIZER_COSTS

Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

FLUSH_STATUS

Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

FLUSH_TABLES

Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

FLUSH_USER_RESOURCES

Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

G

GRANT OPTION

Section 13.7.1.6, “GRANT Statement”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.8, “REVOKE Statement”
Section 13.7.7.21, “SHOW GRANTS Statement”
Section 26.10, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 26.33, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
Section 26.44, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 26.47, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

GROUP_REPLICATION_ADMIN

Section 13.4.3.5, “Functions to Inspect and Configure the Maximum Consensus Instances of a Group”
Section 13.4.3.6, “Functions to Inspect and Set the Group Replication Communication Protocol Version”
Section 13.7.1.6, “GRANT Statement”
Section 18.8, “Group Replication System Variables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 18.4.1.4, “Setting a Group's Communication Protocol Version”
Section 13.4.3.1, “START GROUP_REPLICATION Statement”
Section 13.4.3.2, “STOP GROUP_REPLICATION Statement”
Section 18.4.1.3, “Using Group Replication Group Write Consensus”

I

INDEX

Section 13.1.9, “ALTER TABLE Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

INNODB_REDO_LOG_ARCHIVE

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 15.6.5, “Redo Log”

INNODB_REDO_LOG_ENABLE

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 15.6.5, “Redo Log”
Section 1.3, “What Is New in MySQL 8.0”

INSERT

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 13.1.9, “ALTER TABLE Statement”
Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 6.2.14, “Assigning Account Passwords”
Section 13.7.4.1, “CREATE FUNCTION Statement for User-Defined Functions”
Section 13.7.1.3, “CREATE USER Statement”
Section 13.1.23, “CREATE VIEW Statement”
Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Statement”
Section 13.2.6, “INSERT Statement”
Section 13.7.4.3, “INSTALL COMPONENT Statement”
Section 13.7.4.4, “INSTALL PLUGIN Statement”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.7.1, “Installing and Uninstalling User-Defined Functions”
Section 6.6.1, “MySQL Enterprise Encryption Installation”
Section 13.7.3.4, “OPTIMIZE TABLE Statement”
Section 16.11.1, “Pluggable Storage Engine Architecture”
Section 28.1, “Prerequisites for Using the sys Schema”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Statement”
Section 13.7.3.5, “REPAIR TABLE Statement”
Section 13.2.9, “REPLACE Statement”
Section 17.3.3, “Replication Privilege Checks”
Section 5.1.7, “Server Command Options”
Section 25.6, “Stored Object Access Control”
Section 25.4.6, “The Event Scheduler and MySQL Privileges”
Section 27.12.2.4, “The setup_objects Table”
Section 6.2.10, “Using Roles”

L

LOCK TABLES

Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 15.7.2.4, “Locking Reads”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”

N

NDB_STORED_USER

Section 23.5.12, “Distributed MySQL Privileges with NDB_STORED_USER”
Section 13.7.1.6, “GRANT Statement”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 6.2.2, “Privileges Provided by MySQL”
Section 23.4.23.1.1, “Restoring an NDB backup to a previous version of NDB Cluster”
Section 23.1.4, “What is New in NDB Cluster”

P

PERSIST_RO_VARIABLES_ADMIN

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.8.7, “RESET PERSIST Statement”
Section 5.1.9.1, “System Variable Privileges”

PROCESS

Section 8.14.1, “Accessing the Process List”
Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 15.17.2, “Enabling InnoDB Monitors”
Section 25.4.2, “Event Scheduler Configuration”
Section 13.8.2, “EXPLAIN Statement”
Section 13.7.1.6, “GRANT Statement”
Section 26.1, “Introduction”
Section 13.7.8.4, “KILL Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 23.5.9, “MySQL Server Usage for NDB Cluster”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 28.1, “Prerequisites for Using the sys Schema”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 13.7.7.29, “SHOW PROCESSLIST Statement”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 26.51.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 26.51.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 26.51.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 26.51.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 26.51.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 26.51.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 26.51.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 26.51.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 26.51.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 26.51.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”
Section 26.51.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”
Section 26.51.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”
Section 26.51.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 26.51.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 26.51.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 26.51.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 26.51.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 26.51.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 26.51.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
Section 26.51.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 26.51.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 26.51.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
Section 26.51.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 26.51.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 26.51.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 26.51.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”
Section 26.51.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 26.51.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”
Section 26.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 27.12.19.9, “The processlist Table”
Section 27.12.19.10, “The threads Table”

PROXY

Section 13.7.1.6, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.5, “PAM Pluggable Authentication”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.2.18, “Proxy Users”
Section 2.10.4, “Securing the Initial MySQL Account”
Section 27.12.19.5, “The host_cache Table”
Section 6.4.1.6, “Windows Pluggable Authentication”

PROXY ... WITH GRANT OPTION

Section 6.2.18, “Proxy Users”

R

REFERENCES

Section 13.1.20.5, “FOREIGN KEY Constraints”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

RELOAD

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 2.11.4, “Changes in MySQL 8.0”
Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 13.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.4.1.2, “RESET MASTER Statement”
Section 13.4.2.5, “RESET REPLICA | SLAVE Statement”
Section 13.7.8.6, “RESET Statement”
Section 5.4.6, “Server Log Maintenance”

REPLICATION CLIENT

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.1, “SHOW BINARY LOGS Statement”
Section 13.7.7.23, “SHOW MASTER STATUS Statement”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”

REPLICATION SLAVE

Section 17.1.5.1, “Configuring Multi-Source Replication”
Section 17.1.2.3, “Creating a User for Replication”
Section 13.7.1.6, “GRANT Statement”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 13.7.7.2, “SHOW BINLOG EVENTS Statement”
Section 13.7.7.32, “SHOW RELAYLOG EVENTS Statement”
Section 13.7.7.33, “SHOW REPLICAS | SHOW SLAVE HOSTS Statement”
Section 18.2.1.3, “User Credentials For Distributed Recovery”

REPLICATION_APPLIER

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.7.8.1, “BINLOG Statement”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 13.7.1.6, “GRANT Statement”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3.3, “Replication Privilege Checks”
Section 17.1.6.2, “Replication Source Options and Variables”
Section 5.1.8, “Server System Variables”

REPLICATION_SLAVE_ADMIN

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 13.4.2.9, “STOP REPLICA | SLAVE Statement”

RESOURCE_GROUP_ADMIN

Section 13.7.2.1, “ALTER RESOURCE GROUP Statement”
Section 13.7.2.2, “CREATE RESOURCE GROUP Statement”
Section 13.7.2.3, “DROP RESOURCE GROUP Statement”
Section 13.7.1.6, “GRANT Statement”
Section 8.9.3, “Optimizer Hints”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.16, “Resource Groups”
Section 13.7.2.4, “SET RESOURCE GROUP Statement”

RESOURCE_GROUP_USER

Section 13.7.1.6, “GRANT Statement”
Section 8.9.3, “Optimizer Hints”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.16, “Resource Groups”
Section 13.7.2.4, “SET RESOURCE GROUP Statement”

ROLE_ADMIN

Section 13.7.1.6, “GRANT Statement”
Section 12.16, “Information Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 6.2.10, “Using Roles”

S

SELECT

Section 6.2, “Access Control and Account Management”
Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 6.2.11, “Account Categories”
Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 13.7.3.3, “CHECKSUM TABLE Statement”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.20.3, “CREATE TABLE ... LIKE Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.22, “CREATE TRIGGER Statement”
Section 13.1.23, “CREATE VIEW Statement”
Section 14.7, “Data Dictionary Usage Differences”
Section 13.2.2, “DELETE Statement”
Section 13.7.8.3, “FLUSH Statement”
Section 13.7.1.6, “GRANT Statement”
Section 13.2.6, “INSERT Statement”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 15.7.2.4, “Locking Reads”
Section 5.6.7.9, “Monitoring Cloning Operations”
Section 6.4.7.4, “MySQL Enterprise Firewall Reference”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 23.5.17.2, “NDB Cluster and MySQL Privileges”
Section 13.7.3.4, “OPTIMIZE TABLE Statement”
Section 27.11, “Performance Schema General Table Characteristics”
Section 28.1, “Prerequisites for Using the sys Schema”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.3.5, “REPAIR TABLE Statement”
Section 25.9, “Restrictions on Views”
Section 13.7.1.8, “REVOKE Statement”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.12, “SHOW CREATE USER Statement”
Section 13.7.7.13, “SHOW CREATE VIEW Statement”
Section 13.7.7.21, “SHOW GRANTS Statement”
Section 13.7.7.27, “SHOW PROCEDURE CODE Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 25.6, “Stored Object Access Control”
Section 25.2.2, “Stored Routines and MySQL Privileges”
Section 27.12.19.1, “The error_log Table”
Section 25.4.6, “The Event Scheduler and MySQL Privileges”
Section 26.51.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 26.51.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”
Section 26.46, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 16.7, “The MERGE Storage Engine”
Section 27.12.19.10, “The threads Table”
Section 25.3.1, “Trigger Syntax and Examples”
Section 13.2.13, “UPDATE Statement”

SERVICE_CONNECTION_ADMIN

Section 5.1.12.2, “Administrative Connection Management”
Section 6.2.2, “Privileges Provided by MySQL”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”

SESSION_VARIABLES_ADMIN

Section 13.7.1.6, “GRANT Statement”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.9.1, “System Variable Privileges”

SET_USER_ID

Section 6.2.11, “Account Categories”
Section 13.1.11, “ALTER VIEW Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 13.7.1.5, “DROP USER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Statement”
Section 25.6, “Stored Object Access Control”
Section 25.7, “Stored Program Binary Logging”

SHOW DATABASES

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.7.7.14, “SHOW DATABASES Statement”

SHOW VIEW

Section 13.8.2, “EXPLAIN Statement”
Section 13.7.1.6, “GRANT Statement”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 25.9, “Restrictions on Views”
Section 13.7.7.13, “SHOW CREATE VIEW Statement”
Section 26.48, “The INFORMATION_SCHEMA VIEWS Table”

SHOW_ROUTINE

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.27, “SHOW PROCEDURE CODE Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 25.2.2, “Stored Routines and MySQL Privileges”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”

SHUTDOWN

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 5.6.7.3, “Cloning Remote Data”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.8.8, “RESTART Statement”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 13.7.8.9, “SHUTDOWN Statement”
Section 5.1.19, “The Server Shutdown Process”
Section 4.10, “Unix Signal Handling in MySQL”

SUPER

Section 6.2.11, “Account Categories”
Section 13.7.1, “Account Management Statements”
Section 5.1.12.2, “Administrative Connection Management”
Section 13.1.4, “ALTER FUNCTION Statement”
Section 13.1.5, “ALTER INSTANCE Statement”
Section 13.1.8, “ALTER SERVER Statement”
Section 13.7.1.1, “ALTER USER Statement”
Section 13.1.11, “ALTER VIEW Statement”
Section 6.2.14, “Assigning Account Passwords”
Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.10, “Audit Log Reference”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.7.8.1, “BINLOG Statement”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 5.6.7.12, “Clone System Variables”
Section 10.5, “Configuring Application Character Set and Collation”
Section 5.1.12.1, “Connection Interfaces”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.7.1.2, “CREATE ROLE Statement”
Section 13.1.18, “CREATE SERVER Statement”
Section 13.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement”
Section 13.1.22, “CREATE TRIGGER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 13.7.1.4, “DROP ROLE Statement”
Section 13.1.30, “DROP SERVER Statement”
Section 13.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement”
Section 13.7.1.5, “DROP USER Statement”
Section 18.6.6.4, “Exit Action”
Section 13.7.1.6, “GRANT Statement”
Section 18.8, “Group Replication System Variables”
Section 12.16, “Information Functions”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 6.4.4.13, “Keyring System Variables”
Section 13.7.8.4, “KILL Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.4.4.9, “Migrating Keys Between Keyring Keystores”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 6.5.1, “MySQL Enterprise Data Masking and De-Identification Elements”
Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification User-Defined Function Descriptions”
Section 6.4.7.4, “MySQL Enterprise Firewall Reference”
Section 5.1.15, “MySQL Server Time Zone Support”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.4.4.11, “Plugin-Specific Keyring Key-Management Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Statement”
Section 13.7.8.7, “RESET PERSIST Statement”
Section 13.7.1.8, “REVOKE Statement”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”
Section 13.7.1.10, “SET PASSWORD Statement”
Section 13.3.7, “SET TRANSACTION Statement”
Section 17.1.2, “Setting Up Binary Log File Position Based Replication”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 13.7.7.1, “SHOW BINARY LOGS Statement”
Section 13.7.7.23, “SHOW MASTER STATUS Statement”
Section 13.7.7.29, “SHOW PROCESSLIST Statement”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”
Section 13.4.3.1, “START GROUP_REPLICATION Statement”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 13.4.3.2, “STOP GROUP_REPLICATION Statement”
Section 13.4.2.9, “STOP REPLICA | SLAVE Statement”
Section 25.6, “Stored Object Access Control”
Section 25.7, “Stored Program Binary Logging”
Section 5.1.9.1, “System Variable Privileges”
Section 28.4.4.2, “The diagnostics() Procedure”
Section B.3.2.5, “Too many connections”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”
Section 6.2.10, “Using Roles”
Section 5.6.6.3, “Using Version Tokens”
Section 5.6.6.1, “Version Tokens Elements”
Section 5.6.6.4, “Version Tokens Reference”

SYSTEM_USER

Section 6.2.11, “Account Categories”
Section 13.7.1.6, “GRANT Statement”
Section 12.16, “Information Functions”
Section 13.7.8.4, “KILL Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.7.7.29, “SHOW PROCESSLIST Statement”
Section 25.6, “Stored Object Access Control”
Section 26.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 26.46, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 27.12.19.9, “The processlist Table”
Section 6.2.10, “Using Roles”
Section 1.3, “What Is New in MySQL 8.0”

SYSTEM_VARIABLES_ADMIN

Section 6.4.5.10, “Audit Log Reference”
Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.3, “Cloning Remote Data”
Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.9, “Migrating Keys Between Keyring Keystores”
Section 5.1.15, “MySQL Server Time Zone Support”
Section 6.4.4.11, “Plugin-Specific Keyring Key-Management Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.8.7, “RESET PERSIST Statement”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”
Section 5.1.9.1, “System Variable Privileges”
Section 6.2.10, “Using Roles”

T

TABLE_ENCRYPTION_ADMIN

Section 13.1.2, “ALTER DATABASE Statement”
Section 13.1.9, “ALTER TABLE Statement”
Section 13.1.10, “ALTER TABLESPACE Statement”
Section 13.1.12, “CREATE DATABASE Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 13.7.1.6, “GRANT Statement”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Statement”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

TRIGGER

Section 13.1.22, “CREATE TRIGGER Statement”
Section 13.1.34, “DROP TRIGGER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.11, “SHOW CREATE TRIGGER Statement”
Section 13.7.7.40, “SHOW TRIGGERS Statement”
Section 26.45, “The INFORMATION_SCHEMA TRIGGERS Table”

U

UPDATE

Section 6.2.11, “Account Categories”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.14, “Assigning Account Passwords”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.22, “CREATE TRIGGER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 13.2.6, “INSERT Statement”
Section 15.7.2.4, “Locking Reads”
Section 23.5.17.2, “NDB Cluster and MySQL Privileges”
Section 6.2.15, “Password Management”
Section 27.11, “Performance Schema General Table Characteristics”
Section 27.4, “Performance Schema Runtime Configuration”
Section 27.12.2, “Performance Schema Setup Tables”
Section 28.1, “Prerequisites for Using the sys Schema”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Statement”
Section 13.7.1.8, “REVOKE Statement”
Section 5.1.8, “Server System Variables”
Section 13.7.1.9, “SET DEFAULT ROLE Statement”
Section 13.7.1.10, “SET PASSWORD Statement”
Section 25.6, “Stored Object Access Control”
Section 26.46, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 16.7, “The MERGE Storage Engine”
Section 27.12.2.4, “The setup_objects Table”
Section 25.3.1, “Trigger Syntax and Examples”
Section 13.2.13, “UPDATE Statement”
Section 6.2.10, “Using Roles”

USAGE

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

V

VERSION_TOKEN_ADMIN

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.6.6.3, “Using Version Tokens”
Section 5.6.6.1, “Version Tokens Elements”
Section 5.6.6.4, “Version Tokens Reference”

X

XA_RECOVER_ADMIN

Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.3.8.1, “XA Transaction SQL Statements”

Prev	Up	Next
Option Index	Home	SQL Modes Index