> ## Documentation Index
> Fetch the complete documentation index at: https://doc.lwops.cn/llms.txt
> Use this file to discover all available pages before exploring further.

# 8.2. MySQL\MariaDB

> 8.2.1. 创建监控用户 登录Mysql数据库，执行以下创建语句（如不需要直接使用管理员账号做监控也可以） 主备 > GRANT USAGE,PROCESS,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO 'zbxuser'@'%' IDENTI...

### 8.2.1. 创建监控用户

登录Mysql数据库，执行以下创建语句（如不需要直接使用管理员账号做监控也可以）

```
主备
> GRANT USAGE,PROCESS,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO 'zbxuser'@'%' IDENTIFIED BY 'p@ssw0rd'; #创建授权zbxuser权限并设置密码为'p@ssw0rd'
单机
> GRANT USAGE,PROCESS,SELECT,REPLICATION CLIENT ON *.* TO 'zbxuser'@'%' IDENTIFIED BY 'p@ssw0rd';
> flush privileges;
```

mysql 8 及以上版本需要先创建用户再授权

```sql theme={null}
create user 'zbxuser'@'%' identified by 'P@ssw0rd';
GRANT USAGE,PROCESS,SELECT,REPLICATION CLIENT ON *.* TO 'zbxuser'@'%';
flush privileges;
```

### 8.2.2. 添加监控对象

![8.2. MySQL\MariaDB 操作截图 1](https://lwweb.oss-cn-shenzhen.aliyuncs.com/docs/images/yuque/mysqlmariadb/image-01.png)