zabbix监控mysql

[root@summer mysql]# find / -name user*_mysql.conf
/usr/share/doc/zabbix-agent-5.0.3/userparameter_mysql.conf
[root@summer mysql]# cp /usr/share/doc/zabbix-agent-5.0.3/userparameter_mysql.conf /etc/zabbix/zabbix_agentd.d/
[root@summer mysql]# chown -R zabbix:zabbix /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
[root@summer mysql]# chmod a+x -R /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
[root@summer mysql]# vim /var/lib/zabbix/.my.cnf

[root@summer zabbix]# cat /var/lib/zabbix/.my.cnf
[mysql]
host=localhost
user=root       
password=hadoop     
socket=/home/summer/mysql/mysql.sock

[mysqladmin]
host=localhost
user=root
password=hadoop
socket=/home/summer/mysql/mysql.sock
[root@summer zabbix]# 

[root@localhost ~]# systemctl restart zabbix-agent

zabbix  ALL=(ALL)       NOPASSWD:ALL
Defaults:zabbix    !requiretty