Loading

创建MySQL备份用户

# 创建一个mysql用户,用来备份数据库
CREATE USER 'backupuser'@'localhost' IDENTIFIED BY 'backupuser';
GRANT SELECT, LOCK TABLES, SHOW VIEW, PROCESS  ON *.* TO 'backupuser'@'localhost';

CREATE USER 'backupuser'@'%' IDENTIFIED BY 'backupuser';
GRANT SELECT, LOCK TABLES, SHOW VIEW, PROCESS ON *.* TO 'backupuser'@'%';

FLUSH PRIVILEGES;

 

posted @ 2024-11-05 21:50  Outsrkem  阅读(5)  评论(0编辑  收藏  举报