| 用途 | 细粒度管理权限 |
|---|---|
| 常用 | SYSTEM_VARIABLES_ADMIN / BACKUP_ADMIN / REPLICATION_SLAVE_ADMIN / CONNECTION_ADMIN |
| 特殊 | SYSTEM_USER 区分普通与系统用户 |
授权示例
授权示例
GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'ops'@'10.10.%';
GRANT BACKUP_ADMIN ON *.* TO 'backup'@'localhost';
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'10.0.%';
-- 查看动态权限
SELECT * FROM mysql.global_grants WHERE USER='ops';迁移到 8.0 后若旧脚本依赖 SUPER，逐个映射到对应动态权限，而不是继续兜底给 SUPER。