zabbix monitor mysql
1、grant user for mysqlGRANTUSAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY "zabbix";
2、touch /var/lib/zabbix/.my.cnf
# Zabbix Agent
host=localhost
user=zabbix
password=zabbix
socket=/tmp/mysql.sock
host=localhost
user=zabbix
password=zabbix
socket=/tmp/mysql.sock
3、cp userparameter_mysql.conf/etc/zabbix/zabbix_agentd.d/
HOME=/var/lib/zabbix#where store mysql grant user info ,after itmysql is mysql command full path
4、vim /etc/zabbix/zabbix_agentd.com
Include=/etc/zabbix/zabbix_agentd.d/
5、/etc/init.d/zabbix_agentd restart
6、zabbix_get -s 127.0.0.1 -k mysql.status
7、Apply Template App MySQL
页:
[1]