MySQL 8.4 Release Notes
- 15.7.1.1 ALTER USER 语句15.7.1.1 ALTER USER Statement
- 15.7.1.2 创建角色 Statement15.7.1.2 CREATE ROLE Statement
- 15.7.1.3 CREATE USER 语句15.7.1.3 CREATE USER Statement
- 15.7.1.4 DROP ROLE 语句15.7.1.4 DROP ROLE Statement
- 15.7.1.5 DROP USER 语句15.7.1.5 DROP USER Statement
- 15.7.1.6 GRANT 语句15.7.1.6 GRANT Statement
- 15.7.1.7 RENAME USER 语句15.7.1.7 RENAME USER Statement
- 15.7.1.8 REVOKE 语句15.7.1.8 REVOKE Statement
- 15.7.1.9 SET DEFAULT ROLE 语句15.7.1.9 SET DEFAULT ROLE Statement
- 15.7.1.10 SET 密码语句15.7.1.10 SET PASSWORD Statement
- 15.7.1.11 SET ROLE 语句15.7.1.11 SET ROLE Statement
MySQL account information is stored in the tables of the
mysql system schema. This database and the
access control system are discussed extensively in
Chapter 7, MySQL Server Administration, which you should consult
for additional details.
Important
一些 MySQL 版本在授权表中引入了更改，以添加新的权限或功能。为了确保您能够利用任何新功能，每当升级 MySQL 时，请将您的授权表更新到当前结构。请参阅 第 3 章，升级 MySQL。Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. See Chapter 3, Upgrading MySQL.
当启用 read_only 系统变量时，account-management 语句需要 CONNECTION_ADMIN权限（或已废弃的 SUPER 权限），此外还需其他必要的权限。这是因为它们修改了 mysql。When the read_only system
variable is enabled, account-management statements require the
CONNECTION_ADMIN privilege (or the
deprecated SUPER privilege), in
addition to any other required privileges. This is because they
modify tables in the mysql system schema.
账户管理语句是原子级且安全的。更多信息请参见 第 15.1.1 节，“原子数据定义语句支持”。Account management statements are atomic and crash safe. For more information, see Section 15.1.1, “Atomic Data Definition Statement Support”.