zabbix4.2监控数据库

环境：cencos7.4-zabbix4.2-server  cencos7.4-mariadb

1、 cd /etc/zabbix/zabbix_agentd.d

---

2、Ls

---

3、vim userparameter_mysql.conf

---

4、创建监控mariadb的用户信息

MariaDB [(none)]> GRANT SELECT ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY 'Renwolecom';

MariaDB [(none)]> FLUSH PRIVILEGES;

MariaDB [(none)]> exit

Bye

---

5、创建home目录

mkdir -p /var/lib/zabbix

vim /var/lib/zabbix/.my.cnf

[mysql]

host=localhost

user=zabbix

password="Renwolecom"

socket=/var/lib/mysql/mysql.sock

[mysqladmin]

host=localhost

user=zabbix

password="Renwolecom"

---

6、重启服务

systemctl restart mariadb.service

systemctl restart zabbix-agent.service