MySQL :: MySQL 8.0 Reference Manual :: Privileges Index

Contact MySQL |
Login | Register

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 8.0

5.7
5.6
5.5

5.6 Japanese

MySQL 8.0 Reference Manual / Indexes / Privileges Index

Privileges Index

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

A

ALL

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

ALL PRIVILEGES

Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.6.21, “SHOW GRANTS Syntax”

ALTER

Section 13.1.2, “ALTER DATABASE Syntax”
Section 13.1.9, “ALTER TABLE Syntax”
Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Syntax”
Section 21.4, “Working with InnoDB Cluster”

ALTER ROUTINE

Section 13.1.4, “ALTER FUNCTION Syntax”
Section 13.1.7, “ALTER PROCEDURE Syntax”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.29, “DROP PROCEDURE and DROP FUNCTION Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 24.7, “Stored Program Binary Logging”
Section 24.2.2, “Stored Routines and MySQL Privileges”
Section 21.4, “Working with InnoDB Cluster”

APPLICATION_PASSWORD_ADMIN

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

AUDIT_ADMIN

Section 6.4.5.1, “Audit Log Components”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”

B

BACKUP_ADMIN

Section 2.11.4, “Changes in MySQL 8.0”
Section 13.7.1.6, “GRANT Syntax”
Section 13.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 1.4, “What Is New in MySQL 8.0”

BINLOG_ADMIN

Section 13.7.7.1, “BINLOG Syntax”
Section 13.7.1.6, “GRANT Syntax”
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 Syntax”

BINLOG_ENCRYPTION_ADMIN

Section 13.1.5, “ALTER INSTANCE Syntax”
Section 17.3.10, “Encrypting Binary Log Files and Relay Log Files”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”

C

CONNECTION_ADMIN

Section 6.2.11, “Account Categories”
Section 13.7.1, “Account Management Statements”
Section 13.1.5, “ALTER INSTANCE Syntax”
Section 13.7.1.1, “ALTER USER Syntax”
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 13.7.1.2, “CREATE ROLE Syntax”
Section 13.7.1.3, “CREATE USER Syntax”
Section 13.7.1.4, “DROP ROLE Syntax”
Section 13.7.1.5, “DROP USER Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 8.12.4.1, “How MySQL Handles Client Connections”
Section 13.7.7.4, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Syntax”
Section 13.7.1.8, “REVOKE Syntax”
Section 5.1.8, “Server System Variables”
Section 13.7.1.10, “SET PASSWORD Syntax”
Section 13.3.7, “SET TRANSACTION Syntax”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section B.4.2.6, “Too many connections”

CREATE

Section 13.1.9, “ALTER TABLE Syntax”
Section 13.1.12, “CREATE DATABASE Syntax”
Section 13.1.20, “CREATE TABLE Syntax”
Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Syntax”
Section 13.2.5, “IMPORT TABLE Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Syntax”
Section 21.4, “Working with InnoDB Cluster”

CREATE ROLE

Section 13.7.1.2, “CREATE ROLE Syntax”
Section 13.7.1.6, “GRANT Syntax”
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 Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 24.7, “Stored Program Binary Logging”
Section 24.2.2, “Stored Routines and MySQL Privileges”
Section 21.4, “Working with InnoDB Cluster”

CREATE TABLESPACE

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

CREATE TEMPORARY TABLES

Section 13.1.20.3, “CREATE TEMPORARY TABLE Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 21.4, “Working with InnoDB Cluster”

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 Syntax”
Section 6.2.14, “Assigning Account Passwords”
Section 13.7.1.2, “CREATE ROLE Syntax”
Section 13.7.1.3, “CREATE USER Syntax”
Section 13.7.1.4, “DROP ROLE Syntax”
Section 13.7.1.5, “DROP USER Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.15, “Password Management”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Syntax”
Section 13.7.1.8, “REVOKE Syntax”
Section 13.7.1.9, “SET DEFAULT ROLE Syntax”
Section 13.7.1.10, “SET PASSWORD Syntax”
Section 6.2.10, “Using Roles”
Section 21.4, “Working with InnoDB Cluster”
Section 29.2.4.9.1, “Writing the Server-Side Authentication Plugin”

CREATE VIEW

Section 13.1.11, “ALTER VIEW Syntax”
Section 13.1.23, “CREATE VIEW Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section C.5, “Restrictions on Views”
Section 21.4, “Working with InnoDB Cluster”

D

DELETE

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 13.1.20, “CREATE TABLE Syntax”
Section 13.2.2, “DELETE Syntax”
Section 13.7.4.2, “DROP FUNCTION Syntax”
Section 13.7.1.5, “DROP USER Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.7.1, “Installing and Uninstalling User-Defined Functions”
Section 22.5.12.2, “NDB Cluster and MySQL Privileges”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.2.9, “REPLACE Syntax”
Section 16.7, “The MERGE Storage Engine”
Section 26.12.2.4, “The setup_objects Table”
Section 29.4.2.5, “UDF Compiling and Installing”
Section 29.4.2.6, “UDF Security Precautions”
Section 13.7.4.5, “UNINSTALL COMPONENT Syntax”
Section 13.7.4.6, “UNINSTALL PLUGIN Syntax”
Section 6.2.10, “Using Roles”
Section 21.4, “Working with InnoDB Cluster”

DROP

Section 6.2, “Access Control and Account Management”
Section 13.1.9, “ALTER TABLE Syntax”
Section 13.1.11, “ALTER VIEW Syntax”
Section 13.1.23, “CREATE VIEW Syntax”
Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”
Section 13.1.24, “DROP DATABASE Syntax”
Section 13.1.32, “DROP TABLE Syntax”
Section 13.1.35, “DROP VIEW Syntax”
Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Syntax”
Section 23.3.1, “Management of RANGE and LIST Partitions”
Section 12.19.1, “MySQL Enterprise Encryption Installation”
Section 26.11, “Performance Schema General Table Characteristics”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Syntax”
Section 26.12.17.1, “The host_cache Table”
Section 13.1.37, “TRUNCATE TABLE Syntax”
Section 21.4, “Working with InnoDB Cluster”

DROP ROLE

Section 13.7.1.4, “DROP ROLE Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.2.10, “Using Roles”

E

ENCRYPTION_KEY_ADMIN

Section 13.1.5, “ALTER INSTANCE Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
Section 6.4.4.11, “Keyring System Variables”
Section 6.4.4.6, “Migrating Keys Between Keyring Keystores”
Section 6.2.2, “Privileges Provided by MySQL”

EVENT

Section 13.1.3, “ALTER EVENT Syntax”
Section 13.1.13, “CREATE EVENT Syntax”
Section 13.1.25, “DROP EVENT Syntax”
Section 24.4.1, “Event Scheduler Overview”
Section 24.4.3, “Event Syntax”
Section 13.7.1.6, “GRANT Syntax”
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.6.7, “SHOW CREATE EVENT Syntax”
Section 13.7.6.18, “SHOW EVENTS Syntax”
Section 24.4.6, “The Event Scheduler and MySQL Privileges”
Section 21.4, “Working with InnoDB Cluster”

EXECUTE

Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.29, “DROP PROCEDURE and DROP FUNCTION Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 27.1, “Prerequisites for Using the sys Schema”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 24.6, “Stored Object Access Control”
Section 24.2.2, “Stored Routines and MySQL Privileges”
Section 6.4.4.8.2, “Using General-Purpose Keyring Functions”
Section 21.4, “Working with InnoDB Cluster”

F

FILE

Section 13.1.20, “CREATE TABLE Syntax”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.3, “Grant Tables”
Section 13.2.5, “IMPORT TABLE Syntax”
Section 13.2.7, “LOAD DATA Syntax”
Section 13.2.8, “LOAD XML Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 12.19.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 6.2.2, “Privileges Provided by MySQL”
Section 13.2.10.1, “SELECT ... INTO Syntax”
Section 5.1.8, “Server System Variables”
Section 12.5, “String Functions”
Section 11.4.3, “The BLOB and TEXT Types”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 1.4, “What Is New in MySQL 8.0”
Section 21.4, “Working with InnoDB Cluster”

FIREWALL_ADMIN

Section 13.7.1.6, “GRANT Syntax”
Section 6.4.7.1, “MySQL Enterprise Firewall Components”
Section 6.2.2, “Privileges Provided by MySQL”

FIREWALL_USER

Section 13.7.1.6, “GRANT Syntax”
Section 6.4.7.1, “MySQL Enterprise Firewall Components”
Section 6.2.2, “Privileges Provided by MySQL”

G

GRANT OPTION

Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.8, “REVOKE Syntax”
Section 13.7.6.21, “SHOW GRANTS Syntax”
Section 25.7, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 25.25, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
Section 25.33, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 25.35, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”
Section 21.4, “Working with InnoDB Cluster”

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 Syntax”
Section 18.8, “Group Replication System Variables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 18.4.2.4, “Setting a Group's Communication Protocol Version”
Section 13.4.3.1, “START GROUP_REPLICATION Syntax”
Section 13.4.3.2, “STOP GROUP_REPLICATION Syntax”
Section 18.4.2.3, “Using Group Replication Group Write Consensus”

I

INDEX

Section 13.1.9, “ALTER TABLE Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 21.4, “Working with InnoDB Cluster”

INSERT

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 13.1.9, “ALTER TABLE Syntax”
Section 13.7.3.1, “ANALYZE TABLE Syntax”
Section 6.2.14, “Assigning Account Passwords”
Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.1.3, “CREATE USER Syntax”
Section 13.1.23, “CREATE VIEW Syntax”
Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 13.7.1.6, “GRANT Syntax”
Section 13.2.6, “INSERT Syntax”
Section 13.7.4.3, “INSTALL COMPONENT Syntax”
Section 13.7.4.4, “INSTALL PLUGIN Syntax”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.7.1, “Installing and Uninstalling User-Defined Functions”
Section 12.19.1, “MySQL Enterprise Encryption Installation”
Section 13.7.3.4, “OPTIMIZE TABLE Syntax”
Section 16.11.1, “Pluggable Storage Engine Architecture”
Section 27.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.1.36, “RENAME TABLE Syntax”
Section 13.7.3.5, “REPAIR TABLE Syntax”
Section 13.2.9, “REPLACE Syntax”
Section 5.1.7, “Server Command Options”
Section 24.6, “Stored Object Access Control”
Section 24.4.6, “The Event Scheduler and MySQL Privileges”
Section 26.12.2.4, “The setup_objects Table”
Section 29.4.2.5, “UDF Compiling and Installing”
Section 29.4.2.6, “UDF Security Precautions”
Section 6.2.10, “Using Roles”
Section 21.4, “Working with InnoDB Cluster”

L

LOCK TABLES

Section 13.7.7.3, “FLUSH Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
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”

P

PERSIST_RO_VARIABLES_ADMIN

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

PROCESS

Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 15.16.2, “Enabling InnoDB Monitors”
Section 24.4.2, “Event Scheduler Configuration”
Section 8.14, “Examining Thread Information”
Section 13.7.1.6, “GRANT Syntax”
Section 25.1, “Introduction”
Section 13.7.7.4, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 22.5.4, “MySQL Server Usage for NDB Cluster”
Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 27.1, “Prerequisites for Using the sys Schema”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.6.15, “SHOW ENGINE Syntax”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 25.39.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 25.39.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 25.39.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 25.39.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 25.39.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 25.39.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 25.39.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 25.39.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”
Section 25.39.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”
Section 25.39.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”
Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 25.39.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 25.39.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 25.39.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 25.39.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 25.39.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
Section 25.39.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 25.39.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 25.39.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 25.39.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
Section 25.39.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 25.39.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”
Section 25.39.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 25.39.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”
Section 25.19, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 26.12.17.5, “The threads Table”
Section 21.4, “Working with InnoDB Cluster”

PROXY

Section 13.7.1.6, “GRANT Syntax”
Section 6.2.3, “Grant Tables”
Section 29.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
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 26.12.17.1, “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.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.20.6, “Using FOREIGN KEY Constraints”
Section 21.4, “Working with InnoDB Cluster”

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 8.12.4.2, “DNS Lookup Optimization and the Host Cache”
Section 13.7.7.3, “FLUSH Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.3, “Grant Tables”
Section 13.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Syntax”
Section 28.7.7.58, “mysql_refresh()”
Section 28.7.7.59, “mysql_reload()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.4.1.2, “RESET MASTER Syntax”
Section 13.4.2.4, “RESET SLAVE Syntax”
Section 13.7.7.6, “RESET Syntax”
Section 26.12.17.1, “The host_cache Table”
Section 21.4, “Working with InnoDB Cluster”

REPLICATION CLIENT

Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.6.1, “SHOW BINARY LOGS Syntax”
Section 13.7.6.23, “SHOW MASTER STATUS Syntax”
Section 13.7.6.34, “SHOW SLAVE STATUS Syntax”
Section 21.4, “Working with InnoDB Cluster”

REPLICATION SLAVE

Section 17.1.2.3, “Creating a User for Replication”
Section 13.7.1.6, “GRANT Syntax”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3.9, “Setting Up Replication to Use Encrypted Connections”
Section 13.7.6.2, “SHOW BINLOG EVENTS Syntax”
Section 13.7.6.32, “SHOW RELAYLOG EVENTS Syntax”
Section 13.7.6.33, “SHOW SLAVE HOSTS Syntax”
Section 21.4, “Working with InnoDB Cluster”

REPLICATION-SLAVE

Section 18.2.1.3, “User Credentials”

REPLICATION_SLAVE_ADMIN

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3.11.2, “Semisynchronous Replication Installation and Configuration”
Section 13.4.2.6, “START SLAVE Syntax”
Section 13.4.2.7, “STOP SLAVE Syntax”

RESOURCE_GROUP_ADMIN

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

RESOURCE_GROUP_USER

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

ROLE_ADMIN

Section 13.7.1.6, “GRANT Syntax”
Section 12.15, “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 Syntax”
Section 13.7.3.3, “CHECKSUM TABLE Syntax”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.20.4, “CREATE TABLE ... LIKE Syntax”
Section 13.1.20, “CREATE TABLE Syntax”
Section 13.1.22, “CREATE TRIGGER Syntax”
Section 13.1.23, “CREATE VIEW Syntax”
Section 14.7, “Data Dictionary Usage Differences”
Section 13.2.2, “DELETE Syntax”
Section 13.8.2, “EXPLAIN Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 13.2.6, “INSERT Syntax”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 22.5.12.2, “NDB Cluster and MySQL Privileges”
Section 13.7.3.4, “OPTIMIZE TABLE Syntax”
Section 26.11, “Performance Schema General Table Characteristics”
Section 27.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 Syntax”
Section C.5, “Restrictions on Views”
Section 13.7.1.8, “REVOKE Syntax”
Section 13.7.6.12, “SHOW CREATE USER Syntax”
Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
Section 13.7.6.21, “SHOW GRANTS Syntax”
Section 24.6, “Stored Object Access Control”
Section 24.4.6, “The Event Scheduler and MySQL Privileges”
Section 25.39.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 25.39.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 16.7, “The MERGE Storage Engine”
Section 24.3.1, “Trigger Syntax and Examples”
Section 13.2.12, “UPDATE Syntax”
Section 21.4, “Working with InnoDB Cluster”

SERVICE_CONNECTION_ADMIN

Section 8.12.4.1, “How MySQL Handles Client Connections”
Section 6.2.2, “Privileges Provided by MySQL”

SESSION_VARIABLES_ADMIN

Section 13.7.1.6, “GRANT Syntax”
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 Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 24.6, “Stored Object Access Control”
Section 24.7, “Stored Program Binary Logging”

SHOW DATABASES

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

SHOW VIEW

Section 13.8.2, “EXPLAIN Syntax”
Section 13.7.1.6, “GRANT Syntax”
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 C.5, “Restrictions on Views”
Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
Section 25.36, “The INFORMATION_SCHEMA VIEWS Table”

SHUTDOWN

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.3, “Grant Tables”
Section 28.7.7.75, “mysql_shutdown()”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.8, “RESTART Syntax”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 13.7.7.9, “SHUTDOWN Syntax”
Section 5.1.17, “The Server Shutdown Process”
Section 21.4, “Working with InnoDB Cluster”

SUPER

Section 6.2.11, “Account Categories”
Section 13.7.1, “Account Management Statements”
Section 13.1.4, “ALTER FUNCTION Syntax”
Section 13.1.5, “ALTER INSTANCE Syntax”
Section 13.1.8, “ALTER SERVER Syntax”
Section 13.7.1.1, “ALTER USER Syntax”
Section 13.1.11, “ALTER VIEW Syntax”
Section 6.2.14, “Assigning Account Passwords”
Section 6.4.5.6, “Audit Log Filtering”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.7.7.1, “BINLOG Syntax”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 10.5, “Configuring Application Character Set and Collation”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.7.1.2, “CREATE ROLE Syntax”
Section 13.1.18, “CREATE SERVER Syntax”
Section 13.1.19, “CREATE SPATIAL REFERENCE SYSTEM Syntax”
Section 13.1.22, “CREATE TRIGGER Syntax”
Section 13.7.1.3, “CREATE USER Syntax”
Section 13.7.1.4, “DROP ROLE Syntax”
Section 13.1.30, “DROP SERVER Syntax”
Section 13.1.31, “DROP SPATIAL REFERENCE SYSTEM Syntax”
Section 13.7.1.5, “DROP USER Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 8.12.4.1, “How MySQL Handles Client Connections”
Section 12.15, “Information Functions”
Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
Section 6.4.4.11, “Keyring System Variables”
Section 13.7.7.4, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.4.4.6, “Migrating Keys Between Keyring Keystores”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 6.4.8.1, “MySQL Enterprise Data Masking and De-Identification Components”
Section 6.4.8.4, “MySQL Enterprise Data Masking and De-Identification User-Defined Function Reference”
Section 5.1.13, “MySQL Server Time Zone Support”
Section 28.7.7.12, “mysql_dump_debug_info()”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.4.4.9, “Plugin-Specific Keyring Key-Management Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Syntax”
Section 13.7.7.7, “RESET PERSIST Syntax”
Section 13.7.1.8, “REVOKE Syntax”
Section 17.3.11.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 Syntax”
Section 13.3.7, “SET TRANSACTION Syntax”
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.6.1, “SHOW BINARY LOGS Syntax”
Section 13.7.6.23, “SHOW MASTER STATUS Syntax”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 13.7.6.34, “SHOW SLAVE STATUS Syntax”
Section 13.4.3.1, “START GROUP_REPLICATION Syntax”
Section 13.4.2.6, “START SLAVE Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 13.4.3.2, “STOP GROUP_REPLICATION Syntax”
Section 13.4.2.7, “STOP SLAVE Syntax”
Section 24.6, “Stored Object Access Control”
Section 24.7, “Stored Program Binary Logging”
Section 5.1.9.1, “System Variable Privileges”
Section 27.4.4.2, “The diagnostics() Procedure”
Section B.4.2.6, “Too many connections”
Section 6.4.5.6.1, “Using Audit Log Filtering Functions”
Section 6.2.10, “Using Roles”
Section 5.6.6.3, “Using Version Tokens”
Section 5.6.6.1, “Version Tokens Components”
Section 5.6.6.4, “Version Tokens Reference”
Section 21.4, “Working with InnoDB Cluster”

SYSTEM_USER

Section 6.2.11, “Account Categories”
Section 13.7.1.6, “GRANT Syntax”
Section 12.15, “Information Functions”
Section 13.7.7.4, “KILL Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 24.6, “Stored Object Access Control”
Section 25.19, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 6.2.10, “Using Roles”
Section 1.4, “What Is New in MySQL 8.0”

SYSTEM_VARIABLES_ADMIN

Section 13.7.1.6, “GRANT Syntax”
Section 6.2.3, “Grant Tables”
Section 6.4.4.11, “Keyring System Variables”
Section 6.4.4.6, “Migrating Keys Between Keyring Keystores”
Section 5.1.13, “MySQL Server Time Zone Support”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.7.7, “RESET PERSIST Syntax”
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 Syntax”
Section 13.1.9, “ALTER TABLE Syntax”
Section 13.1.10, “ALTER TABLESPACE Syntax”
Section 13.1.12, “CREATE DATABASE Syntax”
Section 13.1.20, “CREATE TABLE Syntax”
Section 13.1.21, “CREATE TABLESPACE Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Syntax”
Section 5.1.8, “Server System Variables”
Section 1.4, “What Is New in MySQL 8.0”

TRIGGER

Section 13.1.22, “CREATE TRIGGER Syntax”
Section 13.1.34, “DROP TRIGGER Syntax”
Section 13.7.1.6, “GRANT Syntax”
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.6.11, “SHOW CREATE TRIGGER Syntax”
Section 13.7.6.38, “SHOW TRIGGERS Syntax”
Section 25.34, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 21.4, “Working with InnoDB Cluster”

U

UPDATE

Section 6.2.11, “Account Categories”
Section 13.7.1.1, “ALTER USER Syntax”
Section 6.2.14, “Assigning Account Passwords”
Section 13.1.20, “CREATE TABLE Syntax”
Section 13.1.22, “CREATE TRIGGER Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 13.2.6, “INSERT Syntax”
Section 22.5.12.2, “NDB Cluster and MySQL Privileges”
Section 6.2.15, “Password Management”
Section 26.11, “Performance Schema General Table Characteristics”
Section 26.4, “Performance Schema Runtime Configuration”
Section 26.12.2, “Performance Schema Setup Tables”
Section 27.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.1.7, “RENAME USER Syntax”
Section 13.7.1.8, “REVOKE Syntax”
Section 5.1.8, “Server System Variables”
Section 13.7.1.9, “SET DEFAULT ROLE Syntax”
Section 24.6, “Stored Object Access Control”
Section 16.7, “The MERGE Storage Engine”
Section 26.12.2.4, “The setup_objects Table”
Section 24.3.1, “Trigger Syntax and Examples”
Section 13.2.12, “UPDATE Syntax”
Section 6.2.10, “Using Roles”
Section 21.4, “Working with InnoDB Cluster”
Section 29.2.4.9.1, “Writing the Server-Side Authentication Plugin”

USAGE

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

V

VERSION_TOKEN_ADMIN

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

X

XA_RECOVER_ADMIN

Section 13.7.1.6, “GRANT Syntax”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.3.8.1, “XA Transaction SQL Syntax”

PREV HOME UP NEXT