UDB-MySQL如何重建ucloudbackup账户?

发布于 2020-11-19 11:27:05

UDB-MySQL云数据库能重建ucloudbackup账户?怎么操作

查看更多

关注者
0
被浏览
105
1 个回答
云小U
云小U 2020-11-19
绑定邮箱,可随时随地接收消息通知~
  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;

验证
image.png

撰写答案

请登录后再发布答案,点击登录

发布
问题

分享
好友

手机
浏览

扫码手机浏览