创建备份账号
创建备份账号
CREATE USER 'xtrabackup'@'10.0.%' IDENTIFIED BY 'Str0ng#Backup!';
GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES,
REPLICATION CLIENT ON *.* TO 'xtrabackup'@'10.0.%';权限用途
| 权限 | 用途 |
|---|---|
| BACKUP_ADMIN | 8.0 执行备份/克隆所需 |
| PROCESS | 观察线程与锁状态 |
| RELOAD | FLUSH/锁表类操作 |
| LOCK TABLES | 备份非事务引擎表时锁表 |
| REPLICATION CLIENT | 读取 binlog 位点 |
云数据库若不允许 BACKUP_ADMIN，按云厂商文档使用其替代方案（如实例级备份服务）。