创建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;
作者:Outsrkem
原文链接:https://www.cnblogs.com/outsrkem/p/18528941
本文版权归作者所有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。