MySQL :: MySQL 9.1 Reference Manual :: Privileges Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 9.1

9.0
8.4 current
8.0
5.7

MySQL 9.1 Reference Manual / Indexes / Privileges Index

Privileges Index

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

A

ALL

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

ALL PRIVILEGES

Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.22, “SHOW GRANTS Statement”

ALLOW_NONEXISTENT_DEFINER

Section 15.1.11, “ALTER VIEW Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.7.1.5, “DROP USER Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.7, “RENAME USER Statement”
Section 27.7, “Stored Object Access Control”

ALTER

Section 15.1.2, “ALTER DATABASE Statement”
Section 15.1.9, “ALTER TABLE Statement”
Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.1.36, “RENAME TABLE Statement”

ALTER ROUTINE

Section 15.1.4, “ALTER FUNCTION Statement”
Section 15.1.7, “ALTER PROCEDURE Statement”
Section 19.1.6.4, “Binary Logging Options and Variables”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 27.8, “Stored Program Binary Logging”
Section 27.2.2, “Stored Routines and MySQL Privileges”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”

APPLICATION_PASSWORD_ADMIN

Section 15.7.1.1, “ALTER USER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.15, “Password Management”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.10, “SET PASSWORD Statement”

AUDIT_ABORT_EXEMPT

Section 8.2.11, “Account Categories”
Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.1, “Elements of MySQL Enterprise Audit”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.4.5.8, “Writing Audit Log Filter Definitions”

AUDIT_ADMIN

Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.9, “Disabling Audit Logging”
Section 8.4.5.1, “Elements of MySQL Enterprise Audit”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

AUTHENTICATION_POLICY_ADMIN

Section 15.7.1.1, “ALTER USER Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.18, “Multifactor Authentication”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”

B

BACKUP_ADMIN

Section 7.6.7.2, “Cloning Data Locally”
Section 20.5.4.2, “Cloning for Distributed Recovery”
Section 7.6.7.3, “Cloning Remote Data”
Section 20.6.1, “Communication Stack for Connection Security Management”
Section 15.7.1.6, “GRANT Statement”
Section 15.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements”
Section 20.5.4.2.1, “Prerequisites for Cloning”
Section 8.2.2, “Privileges Provided by MySQL”
Section 20.2.1.3, “User Credentials For Distributed Recovery”

BINLOG_ADMIN

Section 15.7.8.1, “BINLOG Statement”
Section 15.7.1.6, “GRANT Statement”
Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 8.2.12, “Privilege Restriction Using Partial Revokes”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.4.1.1, “PURGE BINARY LOGS Statement”

BINLOG_ENCRYPTION_ADMIN

Section 15.1.5, “ALTER INSTANCE Statement”
Section 19.3.2.3, “Binary Log Master Key Rotation”
Section 19.3.2, “Encrypting Binary Log Files and Relay Log Files”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

C

CLONE_ADMIN

Section 7.6.7.13, “Clone System Variables”
Section 7.6.7.3, “Cloning Remote Data”
Section 15.7.1.6, “GRANT Statement”
Section 20.5.4.2.1, “Prerequisites for Cloning”
Section 8.2.2, “Privileges Provided by MySQL”

CONNECTION_ADMIN

Section 8.2.11, “Account Categories”
Section 15.7.1, “Account Management Statements”
Section 7.1.12.2, “Administrative Connection Management”
Section 15.1.5, “ALTER INSTANCE Statement”
Section 15.7.1.1, “ALTER USER Statement”
Section 8.2.14, “Assigning Account Passwords”
Section 20.6.1, “Communication Stack for Connection Security Management”
Section 12.5, “Configuring Application Character Set and Collation”
Section 20.5.1.5, “Configuring Member Actions”
Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 7.1.12.1, “Connection Interfaces”
Section 15.7.1.2, “CREATE ROLE Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.7.1.4, “DROP ROLE Statement”
Section 15.7.1.5, “DROP USER Statement”
Section 20.7.7.4, “Exit Action”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 15.7.1.6, “GRANT Statement”
Section 20.9.1, “Group Replication System Variables”
Section 15.7.8.4, “KILL Statement”
Section 8.1.3, “Making MySQL Secure Against Attackers”
Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.7, “RENAME USER Statement”
Section 8.3.5, “Reusing SSL Sessions”
Section 15.7.1.8, “REVOKE Statement”
Section 7.1.8, “Server System Variables”
Section 15.7.1.10, “SET PASSWORD Statement”
Section 15.3.7, “SET TRANSACTION Statement”
Section 15.7.7.30, “SHOW PROCESSLIST Statement”
Section 15.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section B.3.2.5, “Too many connections”
Section 20.2.1.3, “User Credentials For Distributed Recovery”

CREATE

Section 15.1.9, “ALTER TABLE Statement”
Section 15.1.12, “CREATE DATABASE Statement”
Section 15.1.20, “CREATE TABLE Statement”
Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 15.7.1.6, “GRANT Statement”
Section 15.2.6, “IMPORT TABLE Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.1.36, “RENAME TABLE Statement”

CREATE ROLE

Section 15.7.1.2, “CREATE ROLE Statement”
Section 15.7.1.6, “GRANT Statement”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.2.10, “Using Roles”

CREATE ROUTINE

Section 19.1.6.4, “Binary Logging Options and Variables”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.7.1.6, “GRANT Statement”
Section A.4, “MySQL 9.1 FAQ: Stored Procedures and Functions”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 27.8, “Stored Program Binary Logging”
Section 27.2.2, “Stored Routines and MySQL Privileges”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”

CREATE TABLESPACE

Section 15.1.10, “ALTER TABLESPACE Statement”
Section 17.6.3.3, “General Tablespaces”
Section 15.7.1.6, “GRANT Statement”
Section 17.13, “InnoDB Data-at-Rest Encryption”
Section 8.2.2, “Privileges Provided by MySQL”

CREATE TEMPORARY TABLES

Section 15.1.20.2, “CREATE TEMPORARY TABLE Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

CREATE USER

Section 8.2.11, “Account Categories”
Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 15.7.1.1, “ALTER USER Statement”
Section 8.2.14, “Assigning Account Passwords”
Section 15.7.1.2, “CREATE ROLE Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.7.1.4, “DROP ROLE Statement”
Section 15.7.1.5, “DROP USER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.15, “Password Management”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.7, “RENAME USER Statement”
Section 15.7.1.8, “REVOKE Statement”
Section 15.7.1.9, “SET DEFAULT ROLE Statement”
Section 15.7.1.10, “SET PASSWORD Statement”
Section 28.3.45, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 8.2.10, “Using Roles”
Section 8.4.1.11, “WebAuthn Pluggable Authentication”

CREATE VIEW

Section 15.1.11, “ALTER VIEW Statement”
Section 15.1.23, “CREATE VIEW Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 27.10, “Restrictions on Views”

D

DELETE

Section 8.2.7, “Access Control, Stage 2: Request Verification”
Section 15.1.20, “CREATE TABLE Statement”
Section 15.2.2, “DELETE Statement”
Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”
Section 15.7.1.5, “DROP USER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 7.7.1, “Installing and Uninstalling Loadable Functions”
Section 7.6.1, “Installing and Uninstalling Plugins”
Section 17.7.2.4, “Locking Reads”
Section 25.6.21.2, “NDB Cluster and MySQL Privileges”
Section 8.2.12, “Privilege Restriction Using Partial Revokes”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.2.12, “REPLACE Statement”
Section 18.7, “The MERGE Storage Engine”
Section 29.12.2.4, “The setup_objects Table”
Section 15.7.4.5, “UNINSTALL COMPONENT Statement”
Section 15.7.4.6, “UNINSTALL PLUGIN Statement”
Section 8.2.10, “Using Roles”

DROP

Section 8.2, “Access Control and Account Management”
Section 15.1.9, “ALTER TABLE Statement”
Section 15.1.11, “ALTER VIEW Statement”
Section 15.1.23, “CREATE VIEW Statement”
Section 7.1.12.3, “DNS Lookups and the Host Cache”
Section 15.1.24, “DROP DATABASE Statement”
Section 15.1.32, “DROP TABLE Statement”
Section 15.1.35, “DROP VIEW Statement”
Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 15.7.1.6, “GRANT Statement”
Section 26.3.1, “Management of RANGE and LIST Partitions”
Section 8.6.1, “MySQL Enterprise Encryption Installation and Upgrading”
Section 29.11, “Performance Schema General Table Characteristics”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.1.36, “RENAME TABLE Statement”
Section 29.12.22.3, “The host_cache Table”
Section 15.1.37, “TRUNCATE TABLE Statement”

DROP ROLE

Section 15.7.1.4, “DROP ROLE Statement”
Section 15.7.1.6, “GRANT Statement”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.2.10, “Using Roles”

E

ENCRYPTION_KEY_ADMIN

Section 15.1.5, “ALTER INSTANCE Statement”
Section 15.7.1.6, “GRANT Statement”
Section 17.13, “InnoDB Data-at-Rest Encryption”
Section 8.4.4.17, “Keyring System Variables”
Section 8.4.4.12, “Migrating Keys Between Keyring Keystores”
Section 8.2.2, “Privileges Provided by MySQL”

EVENT

Section 15.1.3, “ALTER EVENT Statement”
Section 15.1.13, “CREATE EVENT Statement”
Section 15.1.25, “DROP EVENT Statement”
Section 27.5.1, “Event Scheduler Overview”
Section 27.5.3, “Event Syntax”
Section 15.7.1.6, “GRANT Statement”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.8, “SHOW CREATE EVENT Statement”
Section 15.7.7.19, “SHOW EVENTS Statement”
Section 27.5.6, “The Event Scheduler and MySQL Privileges”

EXECUTE

Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 8.4.4.13, “General-Purpose Keyring Key-Management Functions”
Section 15.7.1.6, “GRANT Statement”
Section 7.6.7.10, “Monitoring Cloning Operations”
Section 30.1, “Prerequisites for Using the sys Schema”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 27.7, “Stored Object Access Control”
Section 27.2.2, “Stored Routines and MySQL Privileges”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”
Section 8.4.7.3, “Using MySQL Enterprise Firewall”

EXPORT_QUERY_RESULTS

Section 8.2.2, “Privileges Provided by MySQL”

F

FILE

Section 15.1.20, “CREATE TABLE Statement”
Section 9.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.3, “Grant Tables”
Section 15.2.6, “IMPORT TABLE Statement”
Section 15.2.9, “LOAD DATA Statement”
Section 15.2.10, “LOAD XML Statement”
Section 8.1.3, “Making MySQL Secure Against Attackers”
Section 8.6.3, “MySQL Enterprise Encryption Usage and Examples”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.12, “Privilege Restriction Using Partial Revokes”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 19.5.1.20, “Replication and LOAD DATA”
Section 15.2.13.1, “SELECT ... INTO Statement”
Section 7.1.8, “Server System Variables”
Section 14.8, “String Functions and Operators”
Section 13.3.4, “The BLOB and TEXT Types”
Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”

FIREWALL_ADMIN

Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”
Section 15.7.1.6, “GRANT Statement”
Section 8.4.7.4, “MySQL Enterprise Firewall Reference”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.4.7.3, “Using MySQL Enterprise Firewall”

FIREWALL_EXEMPT

Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.4.7.3, “Using MySQL Enterprise Firewall”

FIREWALL_USER

Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.4.7.3, “Using MySQL Enterprise Firewall”

FLUSH_OPTIMIZER_COSTS

Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

FLUSH_PRIVILEGES

Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

FLUSH_STATUS

Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

FLUSH_TABLES

Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”

FLUSH_USER_RESOURCES

Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

G

GRANT OPTION

Section 15.7.1.6, “GRANT Statement”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.8, “REVOKE Statement”
Section 15.7.7.22, “SHOW GRANTS Statement”
Section 28.3.10, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 28.3.33, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
Section 28.3.43, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 28.3.46, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

GROUP_REPLICATION_ADMIN

Section 20.5.1.5, “Configuring Member Actions”
Section 14.18.1.3, “Functions to Inspect and Configure the Maximum Consensus Instances of a Group”
Section 14.18.1.4, “Functions to Inspect and Set the Group Replication Communication Protocol Version”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 15.7.1.6, “GRANT Statement”
Section 20.9.1, “Group Replication System Variables”
Section 8.2.2, “Privileges Provided by MySQL”
Section 20.5.1.4, “Setting a Group's Communication Protocol Version”
Section 15.4.3.1, “START GROUP_REPLICATION Statement”
Section 15.4.3.2, “STOP GROUP_REPLICATION Statement”
Section 20.5.1.3, “Using Group Replication Group Write Consensus”

GROUP_REPLICATION_STREAM

Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”
Section 20.6.1, “Communication Stack for Connection Security Management”
Section 8.2.2, “Privileges Provided by MySQL”
Section 20.6.3.1.2, “Replication User With SSL”
Section 20.2.1.3, “User Credentials For Distributed Recovery”

I

INDEX

Section 15.1.9, “ALTER TABLE Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

INNODB_REDO_LOG_ARCHIVE

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 17.6.5, “Redo Log”

INNODB_REDO_LOG_ENABLE

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 17.6.5, “Redo Log”

INSERT

Section 8.2.7, “Access Control, Stage 2: Request Verification”
Section 15.1.9, “ALTER TABLE Statement”
Section 15.7.3.1, “ANALYZE TABLE Statement”
Section 8.2.14, “Assigning Account Passwords”
Section 15.7.4.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.1.23, “CREATE VIEW Statement”
Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 15.7.1.6, “GRANT Statement”
Section 15.2.7, “INSERT Statement”
Section 15.7.4.3, “INSTALL COMPONENT Statement”
Section 15.7.4.4, “INSTALL PLUGIN Statement”
Section 7.7.1, “Installing and Uninstalling Loadable Functions”
Section 7.6.1, “Installing and Uninstalling Plugins”
Section 8.6.1, “MySQL Enterprise Encryption Installation and Upgrading”
Section 15.7.3.4, “OPTIMIZE TABLE Statement”
Section 18.11.1, “Pluggable Storage Engine Architecture”
Section 30.1, “Prerequisites for Using the sys Schema”
Section 8.2.12, “Privilege Restriction Using Partial Revokes”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.1.36, “RENAME TABLE Statement”
Section 15.7.3.5, “REPAIR TABLE Statement”
Section 15.2.12, “REPLACE Statement”
Section 19.3.3, “Replication Privilege Checks”
Section 7.1.7, “Server Command Options”
Section 27.7, “Stored Object Access Control”
Section 27.5.6, “The Event Scheduler and MySQL Privileges”
Section 29.12.2.4, “The setup_objects Table”
Section 8.2.10, “Using Roles”

L

LOCK TABLES

Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 17.7.2.4, “Locking Reads”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”

M

MASKING_DICTIONARIES_ADMIN

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”
Section 8.5.2, “MySQL Enterprise Data Masking and De-Identification Components”
Section 8.2.2, “Privileges Provided by MySQL”

N

NDB_STORED_USER

Section 15.7.1.6, “GRANT Statement”
Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
Section 25.6.21.2, “NDB Cluster and MySQL Privileges”
Section 25.6.13, “Privilege Synchronization and NDB_STORED_USER”
Section 8.2.2, “Privileges Provided by MySQL”

O

OPTIMIZE_LOCAL_TABLE

Section 15.7.1.6, “GRANT Statement”
Section 15.7.3.4, “OPTIMIZE TABLE Statement”
Section 8.2.2, “Privileges Provided by MySQL”

OPTION_TRACKER_UPDATER

Section 7.5.9.4, “Option Tracker Functions”
Section 7.5.9.1, “Option Tracker Tables”
Section 8.2.2, “Privileges Provided by MySQL”
Section 1.4, “What Is New in MySQL 9.1”

P

PASSWORDLESS_USER_ADMIN

Section 15.7.1.1, “ALTER USER Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.18, “Multifactor Authentication”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.4.1.11, “WebAuthn Pluggable Authentication”

PERSIST_RO_VARIABLES_ADMIN

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.8.7, “RESET PERSIST Statement”
Section 7.1.9.1, “System Variable Privileges”

PROCESS

Section 10.14.1, “Accessing the Process List”
Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 17.17.2, “Enabling InnoDB Monitors”
Section 27.5.2, “Event Scheduler Configuration”
Section 15.8.2, “EXPLAIN Statement”
Section 15.7.1.6, “GRANT Statement”
Section 28.1, “Introduction”
Section 15.7.8.4, “KILL Statement”
Section 8.1.3, “Making MySQL Secure Against Attackers”
Section 25.6.10, “MySQL Server Usage for NDB Cluster”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 10.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 30.1, “Prerequisites for Using the sys Schema”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.16, “SHOW ENGINE Statement”
Section 15.7.7.30, “SHOW PROCESSLIST Statement”
Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”
Section 28.4.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 28.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 28.4.4, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 28.4.5, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 28.4.6, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 28.4.8, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 28.4.7, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 28.4.9, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 28.4.10, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 28.4.11, “The INFORMATION_SCHEMA INNODB_FIELDS Table”
Section 28.4.12, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”
Section 28.4.13, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”
Section 28.4.14, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 28.4.15, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 28.4.16, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 28.4.17, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 28.4.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 28.4.19, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 28.4.20, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
Section 28.4.21, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 28.4.22, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
Section 28.4.23, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 28.4.24, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 28.4.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 28.4.26, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”
Section 28.4.27, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 28.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 28.4.29, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”
Section 28.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 29.12.22.8, “The processlist Table”
Section 29.12.22.9, “The threads Table”

PROXY

Section 15.7.1.6, “GRANT Statement”
Section 8.2.3, “Grant Tables”
Section 8.4.1.6, “LDAP Pluggable Authentication”
Section 8.4.1.4, “PAM Pluggable Authentication”
Section 8.2.2, “Privileges Provided by MySQL”
Section 8.2.19, “Proxy Users”
Section 2.9.4, “Securing the Initial MySQL Account”
Section 29.12.22.3, “The host_cache Table”
Section 8.4.1.5, “Windows Pluggable Authentication”

PROXY ... WITH GRANT OPTION

Section 8.2.19, “Proxy Users”

R

REFERENCES

Section 15.1.20.5, “FOREIGN KEY Constraints”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

RELOAD

Section 8.2.7, “Access Control, Stage 2: Request Verification”
Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 7.1.12.3, “DNS Lookups and the Host Cache”
Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.3, “Grant Tables”
Section 15.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.4.1.2, “RESET BINARY LOGS AND GTIDS Statement”
Section 15.4.2.3, “RESET REPLICA Statement”
Section 15.7.8.6, “RESET Statement”
Section 7.4.6, “Server Log Maintenance”

REPLICATION CLIENT

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.1, “SHOW BINARY LOG STATUS Statement”
Section 15.7.7.2, “SHOW BINARY LOGS Statement”
Section 15.7.7.34, “SHOW REPLICA STATUS Statement”

REPLICATION SLAVE

Section 20.6.1, “Communication Stack for Connection Security Management”
Section 19.1.5.1, “Configuring Multi-Source Replication”
Section 19.1.2.3, “Creating a User for Replication”
Section 15.7.1.6, “GRANT Statement”
Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 8.2.2, “Privileges Provided by MySQL”
Section 19.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 15.7.7.3, “SHOW BINLOG EVENTS Statement”
Section 15.7.7.33, “SHOW RELAYLOG EVENTS Statement”
Section 15.7.7.35, “SHOW REPLICAS Statement”
Section 20.2.1.3, “User Credentials For Distributed Recovery”

REPLICATION_APPLIER

Section 19.1.6.4, “Binary Logging Options and Variables”
Section 15.7.8.1, “BINLOG Statement”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”
Section 19.1.6.5, “Global Transaction ID System Variables”
Section 15.7.1.6, “GRANT Statement”
Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 19.3.3, “Replication Privilege Checks”
Section 19.1.6.2, “Replication Source Options and Variables”
Section 7.1.8, “Server System Variables”

REPLICATION_SLAVE_ADMIN

Section 15.4.2.1, “CHANGE REPLICATION FILTER Statement”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”
Section 15.7.1.6, “GRANT Statement”
Section 19.4.10.1, “Installing Semisynchronous Replication”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.4.2.4, “START REPLICA Statement”
Section 15.4.2.5, “STOP REPLICA Statement”

RESOURCE_GROUP_ADMIN

Section 15.7.2.1, “ALTER RESOURCE GROUP Statement”
Section 15.7.2.2, “CREATE RESOURCE GROUP Statement”
Section 15.7.2.3, “DROP RESOURCE GROUP Statement”
Section 15.7.1.6, “GRANT Statement”
Section 10.9.3, “Optimizer Hints”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.16, “Resource Groups”
Section 15.7.2.4, “SET RESOURCE GROUP Statement”

RESOURCE_GROUP_USER

Section 15.7.1.6, “GRANT Statement”
Section 10.9.3, “Optimizer Hints”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.16, “Resource Groups”
Section 15.7.2.4, “SET RESOURCE GROUP Statement”

ROLE_ADMIN

Section 15.7.1.6, “GRANT Statement”
Section 14.15, “Information Functions”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 8.2.10, “Using Roles”

S

SELECT

Section 8.2, “Access Control and Account Management”
Section 8.2.7, “Access Control, Stage 2: Request Verification”
Section 8.2.11, “Account Categories”
Section 15.7.3.1, “ANALYZE TABLE Statement”
Section 15.7.3.3, “CHECKSUM TABLE Statement”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.1.20.3, “CREATE TABLE ... LIKE Statement”
Section 15.1.20, “CREATE TABLE Statement”
Section 15.1.22, “CREATE TRIGGER Statement”
Section 15.1.23, “CREATE VIEW Statement”
Section 16.7, “Data Dictionary Usage Differences”
Section 15.2.2, “DELETE Statement”
Section 15.7.8.3, “FLUSH Statement”
Section 15.7.1.6, “GRANT Statement”
Section 15.2.7, “INSERT Statement”
Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 17.7.2.4, “Locking Reads”
Section 7.6.7.10, “Monitoring Cloning Operations”
Section 8.4.7.4, “MySQL Enterprise Firewall Reference”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 25.6.21.2, “NDB Cluster and MySQL Privileges”
Section 15.7.3.4, “OPTIMIZE TABLE Statement”
Section 29.11, “Performance Schema General Table Characteristics”
Section 30.1, “Prerequisites for Using the sys Schema”
Section 8.2.12, “Privilege Restriction Using Partial Revokes”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.3.5, “REPAIR TABLE Statement”
Section 27.10, “Restrictions on Views”
Section 15.7.1.8, “REVOKE Statement”
Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”
Section 15.7.7.13, “SHOW CREATE USER Statement”
Section 15.7.7.14, “SHOW CREATE VIEW Statement”
Section 15.7.7.22, “SHOW GRANTS Statement”
Section 15.7.7.28, “SHOW PROCEDURE CODE Statement”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 27.7, “Stored Object Access Control”
Section 27.2.2, “Stored Routines and MySQL Privileges”
Section 29.12.22.2, “The error_log Table”
Section 27.5.6, “The Event Scheduler and MySQL Privileges”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”
Section 28.3.45, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 18.7, “The MERGE Storage Engine”
Section 29.12.22.9, “The threads Table”
Section 27.4.1, “Trigger Syntax and Examples”
Section 15.2.17, “UPDATE Statement”

SENSITIVE_VARIABLES_OBSERVER

Section 29.12.14.2, “Performance Schema persisted_variables Table”
Section 29.12.14, “Performance Schema System Variable Tables”
Section 7.1.9.3, “Persisted System Variables”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.18, “Server Tracking of Client Session State”

SERVICE_CONNECTION_ADMIN

Section 7.1.12.2, “Administrative Connection Management”
Section 8.2.2, “Privileges Provided by MySQL”
Section 20.5.4.1.1, “Selecting addresses for distributed recovery endpoints”

SESSION_VARIABLES_ADMIN

Section 19.1.6.5, “Global Transaction ID System Variables”
Section 15.7.1.6, “GRANT Statement”
Section 10.4.4, “Internal Temporary Table Use in MySQL”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 7.1.9.1, “System Variable Privileges”

SET_ANY_DEFINER

Section 15.1.11, “ALTER VIEW Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 15.7.1.5, “DROP USER Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.7, “RENAME USER Statement”
Section 27.7, “Stored Object Access Control”
Section 27.8, “Stored Program Binary Logging”

SHOW DATABASES

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 15.7.7.15, “SHOW DATABASES Statement”

SHOW VIEW

Section 15.8.2, “EXPLAIN Statement”
Section 15.7.1.6, “GRANT Statement”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”
Section 27.10, “Restrictions on Views”
Section 15.7.7.14, “SHOW CREATE VIEW Statement”
Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”

SHOW_ROUTINE

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”
Section 15.7.7.28, “SHOW PROCEDURE CODE Statement”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 27.2.2, “Stored Routines and MySQL Privileges”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”

SHUTDOWN

Section 8.2.7, “Access Control, Stage 2: Request Verification”
Section 7.6.7.3, “Cloning Remote Data”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.3, “Grant Tables”
Section 6.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.8.8, “RESTART Statement”
Section 19.1.3.4, “Setting Up Replication Using GTIDs”
Section 15.7.8.9, “SHUTDOWN Statement”
Section 7.1.19, “The Server Shutdown Process”
Section 6.10, “Unix Signal Handling in MySQL”

SKIP_QUERY_REWRITE

Section 15.7.1.6, “GRANT Statement”
Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”
Section 19.3.3, “Replication Privilege Checks”
Section 7.6.4, “The Rewriter Query Rewrite Plugin”
Section 7.6.4.2, “Using the Rewriter Query Rewrite Plugin”

SUPER

Section 8.2.11, “Account Categories”
Section 15.7.1, “Account Management Statements”
Section 7.1.12.2, “Administrative Connection Management”
Section 15.1.4, “ALTER FUNCTION Statement”
Section 15.1.5, “ALTER INSTANCE Statement”
Section 15.1.8, “ALTER SERVER Statement”
Section 15.7.1.1, “ALTER USER Statement”
Section 8.2.14, “Assigning Account Passwords”
Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”
Section 19.1.6.4, “Binary Logging Options and Variables”
Section 15.7.8.1, “BINLOG Statement”
Section 15.4.2.1, “CHANGE REPLICATION FILTER Statement”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”
Section 7.6.7.13, “Clone System Variables”
Section 12.5, “Configuring Application Character Set and Collation”
Section 20.5.1.5, “Configuring Member Actions”
Section 7.1.12.1, “Connection Interfaces”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.7.1.2, “CREATE ROLE Statement”
Section 15.1.18, “CREATE SERVER Statement”
Section 15.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement”
Section 15.1.22, “CREATE TRIGGER Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 8.4.5.9, “Disabling Audit Logging”
Section 7.1.12.3, “DNS Lookups and the Host Cache”
Section 15.7.1.4, “DROP ROLE Statement”
Section 15.1.30, “DROP SERVER Statement”
Section 15.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement”
Section 15.7.1.5, “DROP USER Statement”
Section 20.7.7.4, “Exit Action”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 15.7.1.6, “GRANT Statement”
Section 20.9.1, “Group Replication System Variables”
Section 14.15, “Information Functions”
Section 17.13, “InnoDB Data-at-Rest Encryption”
Section 19.4.10.1, “Installing Semisynchronous Replication”
Section 8.4.4.17, “Keyring System Variables”
Section 15.7.8.4, “KILL Statement”
Section 8.1.3, “Making MySQL Secure Against Attackers”
Section 8.4.4.12, “Migrating Keys Between Keyring Keystores”
Section A.4, “MySQL 9.1 FAQ: Stored Procedures and Functions”
Section 8.5.3, “MySQL Enterprise Data Masking and De-Identification Plugin”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.4.7.4, “MySQL Enterprise Firewall Reference”
Section 7.1.15, “MySQL Server Time Zone Support”
Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 8.4.4.14, “Plugin-Specific Keyring Key-Management Functions”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.7, “RENAME USER Statement”
Section 15.7.8.7, “RESET PERSIST Statement”
Section 15.7.1.8, “REVOKE Statement”
Section 7.6.4.3.3, “Rewriter Query Rewrite Plugin System Variables”
Section 7.1.11, “Server SQL Modes”
Section 7.1.8, “Server System Variables”
Section 15.7.1.10, “SET PASSWORD Statement”
Section 15.3.7, “SET TRANSACTION Statement”
Section 19.1.2, “Setting Up Binary Log File Position Based Replication”
Section 19.1.3.4, “Setting Up Replication Using GTIDs”
Section 15.7.7.1, “SHOW BINARY LOG STATUS Statement”
Section 15.7.7.2, “SHOW BINARY LOGS Statement”
Section 15.7.7.30, “SHOW PROCESSLIST Statement”
Section 15.7.7.34, “SHOW REPLICA STATUS Statement”
Section 15.4.3.1, “START GROUP_REPLICATION Statement”
Section 15.4.2.4, “START REPLICA Statement”
Section 15.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 15.4.3.2, “STOP GROUP_REPLICATION Statement”
Section 15.4.2.5, “STOP REPLICA Statement”
Section 27.8, “Stored Program Binary Logging”
Section 7.1.9.1, “System Variable Privileges”
Section 30.4.4.2, “The diagnostics() Procedure”
Section B.3.2.5, “Too many connections”
Section 8.4.7.3, “Using MySQL Enterprise Firewall”
Section 8.2.10, “Using Roles”
Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.1, “Version Tokens Elements”
Section 7.6.6.4, “Version Tokens Reference”

SYSTEM_USER

Section 8.2.11, “Account Categories”
Section 8.4.5.7, “Audit Log Filtering”
Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”
Section 15.7.1.6, “GRANT Statement”
Section 14.15, “Information Functions”
Section 15.7.8.4, “KILL Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 15.7.7.30, “SHOW PROCESSLIST Statement”
Section 27.7, “Stored Object Access Control”
Section 28.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 28.3.45, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 29.12.22.8, “The processlist Table”
Section 8.2.10, “Using Roles”
Section 8.4.5.8, “Writing Audit Log Filter Definitions”

SYSTEM_VARIABLES_ADMIN

Section 8.4.5.11, “Audit Log Reference”
Section 7.6.7.13, “Clone System Variables”
Section 7.6.7.3, “Cloning Remote Data”
Section 8.4.5.9, “Disabling Audit Logging”
Section 7.1.12.3, “DNS Lookups and the Host Cache”
Section 19.1.6.5, “Global Transaction ID System Variables”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.3, “Grant Tables”
Section 10.4.4, “Internal Temporary Table Use in MySQL”
Section 8.4.4.17, “Keyring System Variables”
Section 8.4.4.12, “Migrating Keys Between Keyring Keystores”
Section 7.1.15, “MySQL Server Time Zone Support”
Section 8.4.4.14, “Plugin-Specific Keyring Key-Management Functions”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.8.7, “RESET PERSIST Statement”
Section 7.6.4.3.3, “Rewriter Query Rewrite Plugin System Variables”
Section 7.1.11, “Server SQL Modes”
Section 7.1.8, “Server System Variables”
Section 7.1.9.1, “System Variable Privileges”
Section 8.2.10, “Using Roles”

T

TABLE_ENCRYPTION_ADMIN

Section 15.1.2, “ALTER DATABASE Statement”
Section 15.1.9, “ALTER TABLE Statement”
Section 15.1.10, “ALTER TABLESPACE Statement”
Section 15.1.12, “CREATE DATABASE Statement”
Section 15.1.20, “CREATE TABLE Statement”
Section 15.1.21, “CREATE TABLESPACE Statement”
Section 15.7.1.6, “GRANT Statement”
Section 17.13, “InnoDB Data-at-Rest Encryption”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.1.36, “RENAME TABLE Statement”
Section 7.1.8, “Server System Variables”

TELEMETRY_LOG_ADMIN

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

TP_CONNECTION_ADMIN

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 29.12.16.1, “The tp_connections Table”
Section 7.6.3.3, “Thread Pool Operation”

TRANSACTION_GTID_TAG

Section 19.1.6.5, “Global Transaction ID System Variables”
Section 8.2.2, “Privileges Provided by MySQL”

TRIGGER

Section 15.1.22, “CREATE TRIGGER Statement”
Section 15.1.34, “DROP TRIGGER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.12, “SHOW CREATE TRIGGER Statement”
Section 15.7.7.39, “SHOW TRIGGERS Statement”
Section 28.3.44, “The INFORMATION_SCHEMA TRIGGERS Table”

U

UPDATE

Section 8.2.11, “Account Categories”
Section 15.7.1.1, “ALTER USER Statement”
Section 8.2.14, “Assigning Account Passwords”
Section 15.1.20, “CREATE TABLE Statement”
Section 15.1.22, “CREATE TRIGGER Statement”
Section 15.7.1.6, “GRANT Statement”
Section 15.2.7, “INSERT Statement”
Section 17.7.2.4, “Locking Reads”
Section 25.6.21.2, “NDB Cluster and MySQL Privileges”
Section 8.2.15, “Password Management”
Section 29.11, “Performance Schema General Table Characteristics”
Section 29.4, “Performance Schema Runtime Configuration”
Section 29.12.2, “Performance Schema Setup Tables”
Section 30.1, “Prerequisites for Using the sys Schema”
Section 8.2.12, “Privilege Restriction Using Partial Revokes”
Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.1.7, “RENAME USER Statement”
Section 15.7.1.8, “REVOKE Statement”
Section 7.1.8, “Server System Variables”
Section 15.7.1.9, “SET DEFAULT ROLE Statement”
Section 15.7.1.10, “SET PASSWORD Statement”
Section 27.7, “Stored Object Access Control”
Section 28.3.45, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”
Section 18.7, “The MERGE Storage Engine”
Section 29.12.2.4, “The setup_objects Table”
Section 27.4.1, “Trigger Syntax and Examples”
Section 15.2.17, “UPDATE Statement”
Section 8.2.10, “Using Roles”

USAGE

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”

V

VERSION_TOKEN_ADMIN

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.1, “Version Tokens Elements”
Section 7.6.6.4, “Version Tokens Reference”

X

XA_RECOVER_ADMIN

Section 15.7.1.6, “GRANT Statement”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 15.3.8.1, “XA Transaction SQL Statements”

PREV HOME UP NEXT

PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb