UDB-MySQL如何重建ucloudbackup账户？

1. 创建ucloudbackup账户 (ucloudbackup密码可以联系技术支持获取）

CREATE USER 'ucloudbackup'@'%' IDENTIFIED BY '$udbbakpasswd';

2.向ucloudbackup账户赋权 （以默认提供的root用户为例）

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE ON *.* TO 'ucloudbackup'@'%';

补充赋权

update mysql.user set Super_priv='Y' where User='ucloudbackup';update mysql.user set Shutdown_priv='Y' where User='ucloudbackup';

保存

flush privileges;

验证