### 一、mysql模版

1. mysql监控用户创建,由于zabbix自带监控模板只能监控mysql的基本性能参数,只需建立一个USAGE权限或SELECT权限用户即可,登录主机限制为localhost:

```

GRANT USAGE ON . TO 'zabbixmonitor'@'localhost' IDENTIFIED BY 'passwd';

FLUSH PRIVILEGES;

```

2. zabbix agent配置,检查Include语句是否被注释,如果被注释则取消注释

```

vim /usr/local/zabbix/etc/zabbix_agentd.conf

```

![image-1678953682628](https://zmzycc.top/upload/2023/03/image-1678953682628.png)

3. 新建mysql配置文件,写入数据库连接方式:

```

mkdir /etc/zabbix

vim /etc/zabbix/.my.cnf

[client]

host = localhost

user = zabbixmonitor

password = passwd

```

4. 授权

```

chmod +x /etc/zabbix/.my.cnf

```

```

cp /home/opt/zabbix-5.0.32/conf/zabbix_agentd/userparameter_mysql.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/

vim /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf

```

![image-1678957953312](https://zmzycc.top/upload/2023/03/image-1678957953312.png)

5. 在配置主机里面添加模版

![image-1678958065457](https://zmzycc.top/upload/2023/03/image-1678958065457.png)

完成!