Mysql运维

• Mysql创建备份用户

Mysql创建备份用户

1. 创建用户

CREATE USER 'backup'@'localhost' IDENTIFIED BY '******';

2. 给新用户备份相关权限

# 导出表空间需要'process'权限
GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER, process ON *.* TO 'backup'@'localhost';

3. 刷新权限

FLUSH PRIVILEGES;