创建备份账号
创建备份账号
CREATE USER 'backup'@'10.0.%' IDENTIFIED BY 'Str0ng#Backup!';
GRANT SELECT, SHOW VIEW, TRIGGER, EVENT, LOCK TABLES,
RELOAD, REPLICATION CLIENT, PROCESS
ON *.* TO 'backup'@'10.0.%';
FLUSH PRIVILEGES;权限与用途对照
| 权限 | 用途 |
|---|---|
| SELECT | 读取表数据 |
| SHOW VIEW | 导出视图定义 |
| TRIGGER / EVENT | 导出触发器与事件对象 |
| LOCK TABLES | 旧式锁表备份 |
| RELOAD / REPLICATION CLIENT | 记录 binlog 位点（--source-data） |
| PROCESS | 查看线程与状态信息 |
云数据库权限受限时按平台文档裁剪；账号限制来源主机为备份机内网地址。