zabbix监控模版
### 一、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
```

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
```

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

完成!