# Mysql运维

# Mysql创建备份用户

1\. 创建用户

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

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

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

3\. 刷新权限

```sql
FLUSH PRIVILEGES;
```