MySQL :: MySQL 8.3 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 8.3

8.0 current
5.7

MySQL 8.3 Reference Manual / Indexes / Privileges Index

Privileges Index

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

A

[]

ALL

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

ALL PRIVILEGES

Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.22, “显示授权语句”

ALLOW_NONEXISTENT_DEFINER

Section 8.2.2, “MySQL 提供的权限”
Section 27.6, “存储对象访问控制”

ALTER

Section 15.1.2, “更改数据库语句”
Section 15.1.9, “ALTER TABLE 语句”
Section 26.3.3, “Exchanging Partitions and Subpartitions with 表”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 15.1.36, “RENAME TABLE 语句”

ALTER ROUTINE

Section 15.1.4, “更改函数语句”
Section 15.1.7, “更改存储过程语句”
Section 19.1.6.4, “二进制日志记录选项和变量”
Section 15.1.17, “创建存储过程和创建函数语句”
Section 15.1.29, “删除存储过程和函数语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.10, “显示创建存储过程语句”
Section 15.7.7.30, “显示存储过程状态语句”
Section 27.7, “存储程序二进制日志记录”
Section 27.2.2, “存储例程和 MySQL 权限”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”

APPLICATION_PASSWORD_ADMIN

Section 15.7.1.1, “更改用户语句”
Section 15.7.1.6, “授权语句”
Section 8.2.15, “密码管理”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.10, “设置密码语句”

AUDIT_ABORT_EXEMPT

Section 8.2.11, “账户分类”
Section 8.4.5.7, “审计日志过滤”
Section 8.4.5.1, “Elements of MySQL 企业版审计”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 8.4.5.8, “编写审计日志过滤器定义”

AUDIT_ADMIN

Section 8.4.5.7, “审计日志过滤”
Section 8.4.5.11, “审计日志参考”
Section 8.4.5.9, “禁用审计日志记录”
Section 8.4.5.1, “Elements of MySQL 企业版审计”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

AUTHENTICATION_POLICY_ADMIN

Section 15.7.1.1, “更改用户语句”
Section 15.7.1.3, “创建用户语句”
Section 15.7.1.6, “授权语句”
Section 8.2.18, “多因素认证”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”

B

[]

BACKUP_ADMIN

Section 7.6.7.2, “在本地克隆数据”
Section 20.5.4.2, “Cloning for 分布式恢复”
Section 7.6.7.3, “克隆远程数据”
Section 20.6.1, “Communication Stack for Connection 安全性 Management”
Section 15.7.1.6, “授权语句”
Section 15.3.5, “锁定实例以进行备份和解锁实例语句”

Section 8.2.2, “MySQL 提供的权限”
Section 20.2.1.3, “用于分布式恢复的用户凭据”

BINLOG_ADMIN

Section 15.7.8.1, “BINLOG 语句”
Section 15.7.1.6, “授权语句”
Section 6.6.9, “mysqlbinlog 十六进制转储格式”
Section 8.2.12, “使用部分撤销的权限限制”
Section 8.2.2, “MySQL 提供的权限”
Section 15.4.1.1, “清除二进制日志语句”
Section 1.3, “MySQL 8.3 的新特性”

BINLOG_ENCRYPTION_ADMIN

Section 15.1.5, “更改实例语句”
Section 19.3.2.3, “二进制日志主密钥轮换”
Section 19.3.2, “加密二进制日志文件和中继日志文件”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

C

[]

CLONE_ADMIN

Section 7.6.7.13, “克隆系统变量”
Section 7.6.7.3, “克隆远程数据”
Section 15.7.1.6, “授权语句”

Section 8.2.2, “MySQL 提供的权限”

CONNECTION_ADMIN

Section 8.2.11, “账户分类”
Section 15.7.1, “帐户管理语句”
Section 7.1.12.2, “Administrative 连接管理”
Section 15.1.5, “更改实例语句”
Section 15.7.1.1, “更改用户语句”
Section 8.2.14, “分配帐户密码”
Section 20.6.1, “Communication Stack for Connection 安全性 Management”
Section 12.5, “配置应用程序字符集和排序规则”
Section 20.5.1.5, “配置成员操作”
Section 8.3.1, “配置 MySQL 以使用加密连接”
Section 7.1.12.1, “连接接口”
Section 15.7.1.2, “创建角色语句”
Section 15.7.1.3, “创建用户语句”
Section 15.7.1.4, “删除角色语句”
Section 15.7.1.5, “删除用户语句”
Section 20.7.7.4, “退出操作”
Section 14.18.1.5, “Functions to Set and Reset 组复制 Member Actions”
Section 15.7.1.6, “授权语句”
Section 20.9.1, “组复制 System Variables”
Section 15.7.8.4, “杀死语句”
Section 8.1.3, “保护MySQL免受攻击”
Section 6.5.2, “mysqladmin — A MySQL 服务器管理 Program”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.7, “重命名用户语句”
Section 8.3.5, “重用 SSL 会话”
Section 15.7.1.8, “撤销语句”
Section 7.1.8, “服务器系统变量”
Section 15.7.1.10, “设置密码语句”
Section 15.3.7, “设置事务语句”
Section 15.7.7.31, “显示进程列表语句”
Section 15.3.1, “开始事务、提交和回滚语句”
Section B.3.2.5, “连接过多”
Section 20.2.1.3, “用于分布式恢复的用户凭据”

CREATE

Section 15.1.9, “ALTER TABLE 语句”
Section 15.1.12, “创建数据库语句”
Section 15.1.20, “CREATE TABLE 语句”
Section 26.3.3, “Exchanging Partitions and Subpartitions with 表”
Section 15.7.1.6, “授权语句”
Section 15.2.6, “导入表语句”
Section 8.2.2, “MySQL 提供的权限”
Section 15.1.36, “RENAME TABLE 语句”

CREATE ROLE

Section 15.7.1.2, “创建角色语句”
Section 15.7.1.6, “授权语句”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 8.2.10, “使用角色”

CREATE ROUTINE

Section 19.1.6.4, “二进制日志记录选项和变量”
Section 15.1.17, “创建存储过程和创建函数语句”
Section 15.7.1.6, “授权语句”
Section A.4, “MySQL 8.3 常见问题解答：存储过程和函数”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.10, “显示创建存储过程语句”
Section 15.7.7.30, “显示存储过程状态语句”
Section 27.7, “存储程序二进制日志记录”
Section 27.2.2, “存储例程和 MySQL 权限”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”

CREATE TABLESPACE

Section 15.1.10, “更改表空间语句”
Section 17.6.3.3, “General 表paces”
Section 15.7.1.6, “授权语句”
Section 17.13, “InnoDB 静态数据加密”
Section 8.2.2, “MySQL 提供的权限”

CREATE TEMPORARY TABLES

Section 15.1.20.2, “CREATE TEMPORARY TABLE 语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

CREATE USER

Section 8.2.11, “账户分类”
Section 8.2.8, “添加账户、分配权限和删除账户”
Section 15.7.1.1, “更改用户语句”
Section 8.2.14, “分配帐户密码”
Section 15.7.1.2, “创建角色语句”
Section 15.7.1.3, “创建用户语句”
Section 15.7.1.4, “删除角色语句”
Section 15.7.1.5, “删除用户语句”
Section 8.4.1.12, “FIDO 插件式认证”
Section 15.7.1.6, “授权语句”
Section 8.2.15, “密码管理”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.7, “重命名用户语句”
Section 15.7.1.8, “撤销语句”
Section 15.7.1.9, “设置默认角色语句”
Section 15.7.1.10, “设置密码语句”
Section 28.3.46, “INFORMATION_SCHEMA USER_ATTRIBUTES 表”
Section 8.2.10, “使用角色”
Section 8.4.1.11, “WebAuthn 插件式认证”

CREATE VIEW

Section 15.1.11, “更改视图语句”
Section 15.1.23, “创建视图语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 27.9, “视图的限制”

D

[]

DELETE

Section 8.2.7, “访问控制，第二阶段：请求验证”
Section 15.1.20, “CREATE TABLE 语句”
Section 15.2.2, “删除语句”
Section 15.7.4.2, “可加载函数的 DROP FUNCTION 语句”
Section 15.7.1.5, “删除用户语句”
Section 15.7.1.6, “授权语句”
Section 7.7.1, “安装和卸载可加载函数”
Section 7.6.1, “安装和卸载插件”
Section 17.7.2.4, “锁定读取”
Section 25.6.21.2, “NDB集群和MySQL权限”
Section 8.2.12, “使用部分撤销的权限限制”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 15.2.12, “替换语句”
Section 18.7, “MERGE 存储引擎”
Section 29.12.2.4, “setup_objects 表”
Section 15.7.4.5, “UN安装组件语句”
Section 15.7.4.6, “UN安装插件语句”
Section 8.2.10, “使用角色”

DROP

Section 8.2, “访问控制和账户管理”
Section 15.1.9, “ALTER TABLE 语句”
Section 15.1.11, “更改视图语句”
Section 15.1.23, “创建视图语句”
Section 7.1.12.3, “DNS 查找和主机缓存”
Section 15.1.24, “删除数据库语句”
Section 15.1.32, “删除表语句”
Section 15.1.35, “删除视图语句”
Section 26.3.3, “Exchanging Partitions and Subpartitions with 表”
Section 15.7.1.6, “授权语句”
Section 26.3.1, “RANGE 和 LIST 分区的管理”
Section 8.6.1, “MySQL 企业加密 Installation and Upgrading”
Section 29.11, “性能模式通用表特征”
Section 8.2.2, “MySQL 提供的权限”
Section 15.1.36, “RENAME TABLE 语句”
Section 29.12.22.3, “host_cache 表”
Section 15.1.37, “截断表语句”

DROP ROLE

Section 15.7.1.4, “删除角色语句”
Section 15.7.1.6, “授权语句”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 8.2.10, “使用角色”

E

[]

ENCRYPTION_KEY_ADMIN

Section 15.1.5, “更改实例语句”
Section 15.7.1.6, “授权语句”
Section 17.13, “InnoDB 静态数据加密”
Section 8.4.4.19, “密钥环系统变量”
Section 8.4.4.14, “在密钥环密钥库之间迁移密钥”
Section 8.2.2, “MySQL 提供的权限”

EVENT

Section 15.1.3, “更改事件语句”
Section 15.1.13, “创建事件语句”
Section 15.1.25, “删除事件语句”
Section 27.4.1, “事件调度器概述”
Section 27.4.3, “事件语法”
Section 15.7.1.6, “授权语句”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 6.5.6, “mysqlshow — 显示数据库、表和列信息”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.8, “SHOW 创建事件语句”
Section 15.7.7.19, “显示事件语句”
Section 27.4.6, “事件调度器和 MySQL 权限”

EXECUTE

Section 15.1.17, “创建存储过程和创建函数语句”
Section 15.1.29, “删除存储过程和函数语句”
Section 8.4.4.15, “通用密钥环密钥管理功能”
Section 15.7.1.6, “授权语句”
Section 7.6.7.10, “监控克隆操作”
Section 30.1, “使用 sys Schema 的先决条件”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.10, “显示创建存储过程语句”
Section 15.7.7.30, “显示存储过程状态语句”
Section 27.6, “存储对象访问控制”
Section 27.2.2, “存储例程和 MySQL 权限”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”
Section 8.4.7.3, “Using MySQL 企业防火墙”

F

[]

FILE

Section 15.1.20, “CREATE TABLE 语句”
Section 9.4.3, “使用 mysqldump 转储分隔文本格式的数据”
Section 15.7.1.6, “授权语句”
Section 8.2.3, “授权表”
Section 15.2.6, “导入表语句”
Section 15.2.9, “加载数据语句”
Section 15.2.10, “加载 XML 语句”
Section 8.1.3, “保护MySQL免受攻击”
Section 8.6.3, “MySQL 企业加密 Usage and Examples”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 8.2.12, “使用部分撤销的权限限制”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 19.5.1.19, “复制 and LOAD DATA”
Section 15.2.13.1, “选择...进入语句”
Section 7.1.8, “服务器系统变量”
Section 14.8, “String 函数和运算符”
Section 13.3.4, “BLOB 和 TEXT 类型”
Section 8.2.22, “解决连接 MySQL 问题”

FIREWALL_ADMIN

Section 8.4.7.1, “Elements of MySQL 企业防火墙”
Section 15.7.1.6, “授权语句”
Section 8.4.7.4, “MySQL 企业防火墙 Reference”
Section 8.2.2, “MySQL 提供的权限”
Section 8.4.7.3, “Using MySQL 企业防火墙”

FIREWALL_EXEMPT

Section 8.4.7.1, “Elements of MySQL 企业防火墙”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 8.4.7.3, “Using MySQL 企业防火墙”

FIREWALL_USER

Section 8.4.7.1, “Elements of MySQL 企业防火墙”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 8.4.7.3, “Using MySQL 企业防火墙”

FLUSH_OPTIMIZER_COSTS

Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

FLUSH_STATUS

Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

FLUSH_TABLES

Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

FLUSH_USER_RESOURCES

Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

G

[]

GRANT OPTION

Section 15.7.1.6, “授权语句”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.8, “撤销语句”
Section 15.7.7.22, “显示授权语句”
Section 28.3.10, “INFORMATION_SCHEMA COLUMN_PRIVILEGES 表”
Section 28.3.33, “INFORMATION_SCHEMA SCHEMA_PRIVILEGES 表”
Section 28.3.44, “INFORMATION_SCHEMA TABLE_PRIVILEGES 表”
Section 28.3.47, “INFORMATION_SCHEMA USER_PRIVILEGES 表”

GROUP_REPLICATION_ADMIN

Section 20.5.1.5, “配置成员操作”
Section 14.18.1.3, “检查和配置组的最大共识实例的函数”
Section 14.18.1.4, “Functions to Inspect and Set the 组复制 Communication Protocol Version”
Section 14.18.1.5, “Functions to Set and Reset 组复制 Member Actions”
Section 15.7.1.6, “授权语句”
Section 20.9.1, “组复制 System Variables”
Section 8.2.2, “MySQL 提供的权限”
Section 20.5.1.4, “设置组的通信协议版本”
Section 15.4.3.1, “启动组复制语句”
Section 15.4.3.2, “停止组复制语句”
Section 20.5.1.3, “Using 组复制 Group Write Consensus”

GROUP_REPLICATION_STREAM

Section 15.4.2.3, “将复制源更改为语句”
Section 20.6.1, “Communication Stack for Connection 安全性 Management”
Section 8.2.2, “MySQL 提供的权限”
Section 20.6.3.1.2, “复制 User With SSL”
Section 20.2.1.3, “用于分布式恢复的用户凭据”

I

[]

INDEX

Section 15.1.9, “ALTER TABLE 语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

INNODB_REDO_LOG_ARCHIVE

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 17.6.5, “重做日志”

INNODB_REDO_LOG_ENABLE

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 17.6.5, “重做日志”

INSERT

Section 8.2.7, “访问控制，第二阶段：请求验证”
Section 15.1.9, “ALTER TABLE 语句”
Section 15.7.3.1, “ANALYZE TABLE 语句”
Section 8.2.14, “分配帐户密码”
Section 15.7.4.1, “可加载函数的 CREATE FUNCTION 语句”
Section 15.7.1.3, “创建用户语句”
Section 15.1.23, “创建视图语句”
Section 26.3.3, “Exchanging Partitions and Subpartitions with 表”
Section 15.7.1.6, “授权语句”
Section 15.2.7, “插入语句”
Section 15.7.4.3, “安装组件语句”
Section 15.7.4.4, “安装插件语句”
Section 7.7.1, “安装和卸载可加载函数”
Section 7.6.1, “安装和卸载插件”
Section 8.6.1, “MySQL 企业加密 Installation and Upgrading”
Section 15.7.3.4, “优化表语句”
Section 18.11.1, “可插拔存储引擎架构”
Section 30.1, “使用 sys Schema 的先决条件”
Section 8.2.12, “使用部分撤销的权限限制”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 15.1.36, “RENAME TABLE 语句”
Section 15.7.3.5, “修复表语句”
Section 15.2.12, “替换语句”
Section 19.3.3, “复制 Privilege Checks”
Section 7.1.7, “服务器命令选项”
Section 27.6, “存储对象访问控制”
Section 27.4.6, “事件调度器和 MySQL 权限”
Section 29.12.2.4, “setup_objects 表”
Section 8.2.10, “使用角色”

L

[]

LOCK TABLES

Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 15.3.6, “锁定表和解锁表语句”
Section 17.7.2.4, “锁定读取”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 6.5.6, “mysqlshow — 显示数据库、表和列信息”
Section 8.2.2, “MySQL 提供的权限”

M

[]

MASKING_DICTIONARIES_ADMIN

Section 8.5.2.4, “MySQL 企业数据屏蔽和去标识化 Component Function Descriptions”
Section 8.5.2.1, “MySQL 企业数据屏蔽和去标识化 Component Installation”
Section 8.5.2, “MySQL 企业数据屏蔽和去标识化 Components”
Section 8.2.2, “MySQL 提供的权限”

N

[]

NDB_STORED_USER

Section 15.7.1.6, “授权语句”
Section A.10, “MySQL 8.3 常见问题解答：NDB 集群”
Section 25.6.21.2, “NDB集群和MySQL权限”
Section 25.6.13, “权限同步和 NDB_STORED_USER”
Section 8.2.2, “MySQL 提供的权限”

P

[]

PASSWORDLESS_USER_ADMIN

Section 15.7.1.1, “更改用户语句”
Section 15.7.1.3, “创建用户语句”
Section 8.4.1.12, “FIDO 插件式认证”
Section 15.7.1.6, “授权语句”
Section 8.2.18, “多因素认证”
Section 8.2.2, “MySQL 提供的权限”
Section 8.4.1.11, “WebAuthn 插件式认证”

PERSIST_RO_VARIABLES_ADMIN

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.8.7, “重置 PERSIST 语句”
Section 7.1.9.1, “系统变量权限”

PROCESS

Section 10.14.1, “访问进程列表”
Section 8.2.8, “添加账户、分配权限和删除账户”
Section 17.17.2, “Enabling InnoDB 监视器”
Section 27.4.2, “事件调度器配置”
Section 15.8.2, “解释语句”
Section 15.7.1.6, “授权语句”
Section 28.1, “简介”
Section 15.7.8.4, “杀死语句”
Section 8.1.3, “保护MySQL免受攻击”
Section 25.6.10, “NDB 集群的 MySQL 服务器用法”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 10.8.4, “获取命名连接的执行计划信息”
Section 30.1, “使用 sys Schema 的先决条件”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.16, “显示引擎语句”
Section 15.7.7.31, “显示进程列表语句”
Section 28.3.15, “INFORMATION_SCHEMA FILES 表”
Section 28.4.2, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE 表”
Section 28.4.3, “INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 表”
Section 28.4.4, “INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 表”
Section 28.4.5, “INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表”
Section 28.4.6, “INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET 表”
Section 28.4.8, “INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET 表”
Section 28.4.7, “INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET 表”
Section 28.4.9, “INFORMATION_SCHEMA INNODB_COLUMNS 表”
Section 28.4.10, “INFORMATION_SCHEMA INNODB_DATAFILES 表”
Section 28.4.11, “INFORMATION_SCHEMA INNODB_FIELDS 表”
Section 28.4.12, “INFORMATION_SCHEMA INNODB_FOREIGN 表”
Section 28.4.13, “INFORMATION_SCHEMA INNODB_FOREIGN_COLS 表”
Section 28.4.14, “INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表”
Section 28.4.15, “INFORMATION_SCHEMA INNODB_FT_CONFIG 表”
Section 28.4.16, “INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表”
Section 28.4.17, “INFORMATION_SCHEMA INNODB_FT_DELETED 表”
Section 28.4.18, “INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 表”
Section 28.4.19, “INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 表”
Section 28.4.20, “INFORMATION_SCHEMA INNODB_INDEXES 表”
Section 28.4.21, “INFORMATION_SCHEMA INNODB_METRICS 表”
Section 28.4.22, “INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 表”
Section 28.4.23, “INFORMATION_SCHEMA INNODB_TABLES 表”
Section 28.4.24, “INFORMATION_SCHEMA INNODB_TABLESPACES 表”
Section 28.4.25, “INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表”
Section 28.4.26, “INFORMATION_SCHEMA INNODB_TABLESTATS 视图”
Section 28.4.27, “INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 表”
Section 28.4.28, “INFORMATION_SCHEMA INNODB_TRX 表”
Section 28.4.29, “INFORMATION_SCHEMA INNODB_VIRTUAL 表”
Section 28.3.23, “INFORMATION_SCHEMA PROCESSLIST 表”
Section 29.12.22.7, “processlist 表”
Section 29.12.22.8, “threads 表”

PROXY

Section 15.7.1.6, “授权语句”
Section 8.2.3, “授权表”
Section 8.4.1.7, “LDAP 插件式认证”
Section 8.4.1.5, “PAM 插件式认证”
Section 8.2.2, “MySQL 提供的权限”
Section 8.2.19, “代理用户”
Section 2.9.4, “保护初始 MySQL 帐户”
Section 29.12.22.3, “host_cache 表”
Section 8.4.1.6, “Windows 插件式认证”

PROXY ... WITH GRANT OPTION

Section 8.2.19, “代理用户”

R

[]

REFERENCES

Section 15.1.20.5, “外键约束”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

RELOAD

Section 8.2.7, “访问控制，第二阶段：请求验证”
Section 8.2.8, “添加账户、分配权限和删除账户”
Section 7.1.12.3, “DNS 查找和主机缓存”
Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 8.2.3, “授权表”
Section 15.3.5, “锁定实例以进行备份和解锁实例语句”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 8.2.2, “MySQL 提供的权限”
Section 15.4.1.2, “重置二进制日志和 GTID 语句”
Section 15.4.1.3, “重置主服务器语句”
Section 15.4.2.4, “重置副本语句”
Section 15.7.8.6, “重置语句”
Section 7.4.6, “服务器日志维护”

REPLICATION CLIENT

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.2, “显示二进制日志状态语句”
Section 15.7.7.1, “显示二进制日志语句”
Section 15.7.7.24, “显示主服务器状态语句”
Section 15.7.7.37, “显示副本状态语句”

REPLICATION SLAVE

Section 20.6.1, “Communication Stack for Connection 安全性 Management”
Section 19.1.5.1, “Configuring Multi-Source 复制”
Section 19.1.2.3, “Creating a User for 复制”
Section 15.7.1.6, “授权语句”
Section 6.6.9, “mysqlbinlog 十六进制转储格式”
Section 8.2.2, “MySQL 提供的权限”
Section 19.3.1, “Setting Up 复制 to Use Encrypted Connections”
Section 15.7.7.3, “显示二进制日志事件语句”
Section 15.7.7.34, “显示中继日志事件语句”
Section 15.7.7.35, “显示副本语句”
Section 20.2.1.3, “用于分布式恢复的用户凭据”

REPLICATION_APPLIER

Section 19.1.6.4, “二进制日志记录选项和变量”
Section 15.7.8.1, “BINLOG 语句”
Section 15.4.2.3, “将复制源更改为语句”
Section 19.1.6.5, “全局事务 ID 系统变量”
Section 15.7.1.6, “授权语句”
Section 6.6.9, “mysqlbinlog 十六进制转储格式”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 19.3.3, “复制 Privilege Checks”
Section 19.1.6.2, “复制 Source Options and Variables”
Section 7.1.8, “服务器系统变量”

REPLICATION_SLAVE_ADMIN

Section 15.4.2.2, “更改复制过滤器语句”
Section 15.4.2.3, “将复制源更改为语句”
Section 15.7.1.6, “授权语句”
Section 19.4.10.1, “Installing Semisynchronous 复制”
Section 8.2.2, “MySQL 提供的权限”
Section 15.4.2.6, “启动副本语句”
Section 15.4.2.8, “停止副本语句”

RESOURCE_GROUP_ADMIN

Section 15.7.2.1, “更改资源组语句”
Section 15.7.2.2, “创建资源组语句”
Section 15.7.2.3, “删除资源组语句”
Section 15.7.1.6, “授权语句”
Section 10.9.3, “优化器提示”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.16, “资源组”
Section 15.7.2.4, “设置资源组语句”

RESOURCE_GROUP_USER

Section 15.7.1.6, “授权语句”
Section 10.9.3, “优化器提示”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.16, “资源组”
Section 15.7.2.4, “设置资源组语句”

ROLE_ADMIN

Section 15.7.1.6, “授权语句”
Section 14.15, “信息函数”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 8.2.10, “使用角色”

S

[]

SELECT

Section 8.2, “访问控制和账户管理”
Section 8.2.7, “访问控制，第二阶段：请求验证”
Section 8.2.11, “账户分类”
Section 15.7.3.1, “ANALYZE TABLE 语句”
Section 15.7.3.3, “CHECKSUM TABLE 语句”
Section 15.1.17, “创建存储过程和创建函数语句”
Section 15.1.20.3, “创建表...像语句”
Section 15.1.20, “CREATE TABLE 语句”
Section 15.1.22, “创建触发器语句”
Section 15.1.23, “创建视图语句”
Section 16.7, “数据字典使用差异”
Section 15.2.2, “删除语句”
Section 15.7.8.3, “刷新语句”
Section 15.7.1.6, “授权语句”
Section 15.2.7, “插入语句”
Section 15.3.6, “锁定表和解锁表语句”
Section 17.7.2.4, “锁定读取”
Section 7.6.7.10, “监控克隆操作”
Section 8.4.7.4, “MySQL 企业防火墙 Reference”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 6.5.6, “mysqlshow — 显示数据库、表和列信息”
Section 25.6.21.2, “NDB集群和MySQL权限”
Section 15.7.3.4, “优化表语句”
Section 29.11, “性能模式通用表特征”
Section 30.1, “使用 sys Schema 的先决条件”
Section 8.2.12, “使用部分撤销的权限限制”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.3.5, “修复表语句”
Section 27.9, “视图的限制”
Section 15.7.1.8, “撤销语句”
Section 15.7.7.10, “显示创建存储过程语句”
Section 15.7.7.13, “显示创建用户语句”
Section 15.7.7.14, “显示创建视图语句”
Section 15.7.7.22, “显示授权语句”
Section 15.7.7.29, “显示存储过程代码语句”
Section 15.7.7.30, “显示存储过程状态语句”
Section 27.6, “存储对象访问控制”
Section 27.2.2, “存储例程和 MySQL 权限”
Section 29.12.22.2, “error_log 表”
Section 27.4.6, “事件调度器和 MySQL 权限”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”
Section 28.3.46, “INFORMATION_SCHEMA USER_ATTRIBUTES 表”
Section 18.7, “MERGE 存储引擎”
Section 29.12.22.8, “threads 表”
Section 27.3.1, “触发器语法和示例”
Section 15.2.17, “更新语句”

SENSITIVE_VARIABLES_OBSERVER

Section 29.12.14.1, “Performance Schema persisted_variables 表”
Section 29.12.14, “Performance Schema System Variable 表”
Section 7.1.9.3, “持久化的系统变量”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.18, “服务器跟踪客户端会话状态”

SERVICE_CONNECTION_ADMIN

Section 7.1.12.2, “Administrative 连接管理”
Section 8.2.2, “MySQL 提供的权限”

SESSION_VARIABLES_ADMIN

Section 19.1.6.5, “全局事务 ID 系统变量”
Section 15.7.1.6, “授权语句”
Section 10.4.4, “MySQL中内部临时表的使用”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 7.1.9.1, “系统变量权限”

SET_ANY_DEFINER

Section 8.2.2, “MySQL 提供的权限”
Section 27.6, “存储对象访问控制”
Section 27.7, “存储程序二进制日志记录”

SET_USER_ID

Section 8.2.11, “账户分类”
Section 15.1.11, “更改视图语句”
Section 15.7.1.3, “创建用户语句”
Section 15.7.1.5, “删除用户语句”
Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.7, “重命名用户语句”
Section 27.6, “存储对象访问控制”
Section 27.7, “存储程序二进制日志记录”

SHOW DATABASES

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.15, “显示数据库语句”

SHOW VIEW

Section 15.8.2, “解释语句”
Section 15.7.1.6, “授权语句”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 6.5.6, “mysqlshow — 显示数据库、表和列信息”
Section 8.2.2, “MySQL 提供的权限”
Section 27.9, “视图的限制”
Section 15.7.7.14, “显示创建视图语句”
Section 28.3.48, “INFORMATION_SCHEMA VIEWS 表”

SHOW_ROUTINE

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.10, “显示创建存储过程语句”
Section 15.7.7.29, “显示存储过程代码语句”
Section 15.7.7.30, “显示存储过程状态语句”
Section 27.2.2, “存储例程和 MySQL 权限”
Section 28.3.30, “INFORMATION_SCHEMA ROUTINES 表”

SHUTDOWN

Section 8.2.7, “访问控制，第二阶段：请求验证”
Section 7.6.7.3, “克隆远程数据”
Section 15.7.1.6, “授权语句”
Section 8.2.3, “授权表”
Section 6.3.4, “mysqld_multi — 管理多个 MySQL 服务器”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.8.8, “重启语句”
Section 19.1.3.4, “Setting Up 复制 Using GTIDs”
Section 15.7.8.9, “关闭语句”
Section 7.1.19, “服务器关闭过程”
Section 6.10, “MySQL 中的 Unix 信号处理”

SKIP_QUERY_REWRITE

Section 15.7.1.6, “授权语句”
Section 6.5.2, “mysqladmin — A MySQL 服务器管理 Program”
Section 6.6.9, “mysqlbinlog 十六进制转储格式”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 6.5.6, “mysqlshow — 显示数据库、表和列信息”
Section 8.2.2, “MySQL 提供的权限”
Section 19.3.3, “复制 Privilege Checks”
Section 7.6.4, “重写器查询重写插件”
Section 7.6.4.2, “使用重写器查询重写插件”

SUPER

Section 8.2.11, “账户分类”
Section 15.7.1, “帐户管理语句”
Section 7.1.12.2, “Administrative 连接管理”
Section 15.1.4, “更改函数语句”
Section 15.1.5, “更改实例语句”
Section 15.1.8, “更改服务器语句”
Section 15.7.1.1, “更改用户语句”
Section 15.1.11, “更改视图语句”
Section 8.2.14, “分配帐户密码”
Section 8.4.5.7, “审计日志过滤”
Section 8.4.5.11, “审计日志参考”
Section 19.1.6.4, “二进制日志记录选项和变量”
Section 15.7.8.1, “BINLOG 语句”
Section 15.4.2.2, “更改复制过滤器语句”
Section 15.4.2.3, “将复制源更改为语句”
Section 7.6.7.13, “克隆系统变量”
Section 12.5, “配置应用程序字符集和排序规则”
Section 20.5.1.5, “配置成员操作”
Section 7.1.12.1, “连接接口”
Section 15.1.17, “创建存储过程和创建函数语句”
Section 15.7.1.2, “创建角色语句”
Section 15.1.18, “创建服务器语句”
Section 15.1.19, “创建空间参考系统语句”
Section 15.1.22, “创建触发器语句”
Section 15.7.1.3, “创建用户语句”
Section 8.4.5.9, “禁用审计日志记录”
Section 7.1.12.3, “DNS 查找和主机缓存”
Section 15.7.1.4, “删除角色语句”
Section 15.1.30, “删除服务器语句”
Section 15.1.31, “删除空间参考系统语句”
Section 15.7.1.5, “删除用户语句”
Section 20.7.7.4, “退出操作”
Section 14.18.1.5, “Functions to Set and Reset 组复制 Member Actions”
Section 15.7.1.6, “授权语句”
Section 20.9.1, “组复制 System Variables”
Section 14.15, “信息函数”
Section 17.13, “InnoDB 静态数据加密”
Section 19.4.10.1, “Installing Semisynchronous 复制”
Section 8.4.4.19, “密钥环系统变量”
Section 15.7.8.4, “杀死语句”
Section 8.1.3, “保护MySQL免受攻击”
Section 8.4.4.14, “在密钥环密钥库之间迁移密钥”
Section A.4, “MySQL 8.3 常见问题解答：存储过程和函数”
Section 8.5.3, “MySQL 企业数据屏蔽和去标识化 Plugin”
Section 8.5.3.4, “MySQL 企业数据屏蔽和去标识化 Plugin Function Descriptions”
Section 8.4.7.4, “MySQL 企业防火墙 Reference”
Section 7.1.15, “MySQL 服务器时区支持”
Section 6.5.2, “mysqladmin — A MySQL 服务器管理 Program”
Section 6.6.9, “mysqlbinlog 十六进制转储格式”
Section 8.4.4.16, “插件特定的密钥环密钥管理功能”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.7, “重命名用户语句”
Section 15.7.8.7, “重置 PERSIST 语句”
Section 15.7.1.8, “撤销语句”

Section 7.1.11, “服务器 SQL 模式”
Section 7.1.8, “服务器系统变量”
Section 15.7.1.10, “设置密码语句”
Section 15.3.7, “设置事务语句”
Section 19.1.2, “Setting Up Binary Log File Position Based 复制”
Section 19.1.3.4, “Setting Up 复制 Using GTIDs”
Section 15.7.7.2, “显示二进制日志状态语句”
Section 15.7.7.1, “显示二进制日志语句”
Section 15.7.7.24, “显示主服务器状态语句”
Section 15.7.7.31, “显示进程列表语句”
Section 15.7.7.37, “显示副本状态语句”
Section 15.4.3.1, “启动组复制语句”
Section 15.4.2.6, “启动副本语句”
Section 15.3.1, “开始事务、提交和回滚语句”
Section 15.4.3.2, “停止组复制语句”
Section 15.4.2.8, “停止副本语句”
Section 27.6, “存储对象访问控制”
Section 27.7, “存储程序二进制日志记录”
Section 7.1.9.1, “系统变量权限”
Section 30.4.4.2, “The diagnostics() Procedure”
Section B.3.2.5, “连接过多”
Section 8.4.7.3, “Using MySQL 企业防火墙”
Section 8.2.10, “使用角色”
Section 7.6.6.3, “Using 版本令牌”
Section 7.6.6.1, “版本令牌 Elements”
Section 7.6.6.4, “版本令牌 Reference”

SYSTEM_USER

Section 8.2.11, “账户分类”
Section 8.4.5.7, “审计日志过滤”
Section 15.1.29, “删除存储过程和函数语句”
Section 15.7.1.6, “授权语句”
Section 14.15, “信息函数”
Section 15.7.8.4, “杀死语句”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 15.7.7.31, “显示进程列表语句”
Section 27.6, “存储对象访问控制”
Section 28.3.23, “INFORMATION_SCHEMA PROCESSLIST 表”
Section 28.3.46, “INFORMATION_SCHEMA USER_ATTRIBUTES 表”
Section 29.12.22.7, “processlist 表”
Section 8.2.10, “使用角色”
Section 8.4.5.8, “编写审计日志过滤器定义”

SYSTEM_VARIABLES_ADMIN

Section 8.4.5.11, “审计日志参考”
Section 7.6.7.13, “克隆系统变量”
Section 7.6.7.3, “克隆远程数据”
Section 8.4.5.9, “禁用审计日志记录”
Section 7.1.12.3, “DNS 查找和主机缓存”
Section 19.1.6.5, “全局事务 ID 系统变量”
Section 15.7.1.6, “授权语句”
Section 8.2.3, “授权表”
Section 10.4.4, “MySQL中内部临时表的使用”
Section 8.4.4.19, “密钥环系统变量”
Section 8.4.4.14, “在密钥环密钥库之间迁移密钥”
Section 7.1.15, “MySQL 服务器时区支持”
Section 8.4.4.16, “插件特定的密钥环密钥管理功能”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.8.7, “重置 PERSIST 语句”

Section 7.1.11, “服务器 SQL 模式”
Section 7.1.8, “服务器系统变量”
Section 7.1.9.1, “系统变量权限”
Section 8.2.10, “使用角色”

T

[]

TABLE_ENCRYPTION_ADMIN

Section 15.1.2, “更改数据库语句”
Section 15.1.9, “ALTER TABLE 语句”
Section 15.1.10, “更改表空间语句”
Section 15.1.12, “创建数据库语句”
Section 15.1.20, “CREATE TABLE 语句”
Section 15.1.21, “创建表空间语句”
Section 15.7.1.6, “授权语句”
Section 17.13, “InnoDB 静态数据加密”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 15.1.36, “RENAME TABLE 语句”
Section 7.1.8, “服务器系统变量”

TELEMETRY_LOG_ADMIN

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

TP_CONNECTION_ADMIN

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 29.12.16.1, “tp_connections 表”
Section 7.6.3.3, “线程池操作”

TRANSACTION_GTID_TAG

Section 19.1.6.5, “全局事务 ID 系统变量”
Section 8.2.2, “MySQL 提供的权限”
Section 1.3, “MySQL 8.3 的新特性”

TRIGGER

Section 15.1.22, “创建触发器语句”
Section 15.1.34, “删除触发器语句”
Section 15.7.1.6, “授权语句”
Section 6.5.4, “mysqlimport — 数据导入程序”
Section 6.5.6, “mysqlshow — 显示数据库、表和列信息”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.7.12, “SHOW 创建触发器语句”
Section 15.7.7.42, “显示触发器语句”
Section 28.3.45, “INFORMATION_SCHEMA TRIGGERS 表”

U

[]

UPDATE

Section 8.2.11, “账户分类”
Section 15.7.1.1, “更改用户语句”
Section 8.2.14, “分配帐户密码”
Section 15.1.20, “CREATE TABLE 语句”
Section 15.1.22, “创建触发器语句”
Section 15.7.1.6, “授权语句”
Section 15.2.7, “插入语句”
Section 17.7.2.4, “锁定读取”
Section 25.6.21.2, “NDB集群和MySQL权限”
Section 8.2.15, “密码管理”
Section 29.11, “性能模式通用表特征”
Section 29.4, “性能模式运行时配置”
Section 29.12.2, “Performance Schema Setup 表”
Section 30.1, “使用 sys Schema 的先决条件”
Section 8.2.12, “使用部分撤销的权限限制”
Section 19.3.3.1, “Privileges For The 复制 PRIVILEGE_CHECKS_USER Account”
Section 8.2.2, “MySQL 提供的权限”
Section 15.7.1.7, “重命名用户语句”
Section 15.7.1.8, “撤销语句”
Section 7.1.8, “服务器系统变量”
Section 15.7.1.9, “设置默认角色语句”
Section 15.7.1.10, “设置密码语句”
Section 27.6, “存储对象访问控制”
Section 28.3.46, “INFORMATION_SCHEMA USER_ATTRIBUTES 表”
Section 18.7, “MERGE 存储引擎”
Section 29.12.2.4, “setup_objects 表”
Section 27.3.1, “触发器语法和示例”
Section 15.2.17, “更新语句”
Section 8.2.10, “使用角色”

USAGE

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”

V

[]

VERSION_TOKEN_ADMIN

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 7.6.6.3, “Using 版本令牌”
Section 7.6.6.1, “版本令牌 Elements”
Section 7.6.6.4, “版本令牌 Reference”

X

[]

XA_RECOVER_ADMIN

Section 15.7.1.6, “授权语句”
Section 8.2.2, “MySQL 提供的权限”
Section 7.1.8, “服务器系统变量”
Section 15.3.8.1, “XA 事务 SQL 语句”

PREV HOME UP NEXT