5.25-zabbix监控MySQL

授权一个监控用户

> grant usage, process, replication client on *.* to 'mon'@'localhost' identified by 'x2ay9xodTvyM';

编辑配置文件

vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
mkdir /var/lib/zabbix
vi /var/lib/zabbix/.my.cnf #如下内容
[mysql]
host=localhost
user=mon
password='x2ay9xodTvyM'
socket=/tmp/mysql.sock

[mysqladmin]
host=localhost
user=mon
password='x2ay9xodTvyM'
socket=/tmp/mysql.sock

重启zabbix-agent服务

systemctl restart zabbix-agent

测试

zabbix_get -s 127.0.0.1 -p 10050 -k mysql.ping
若提示：sh: mysqladmin: 未找到命令
需要： ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/	

zabbix_get -s 127.0.0.1 -p 10050 -k mysql.version
zabbix_get -s 127.0.0.1 -p 10050 -k mysql.size

添加主机和模板

Configuration -> Hosts -> Create host
Agent interfaces -> 127.0.0.1 10050
Templates -> Select -> Template DB MySQL -> select -> Add
Add