zabbix用自带的模块监控mysql不显示的问题

客户端配置监控mysql 数据库授权mysql> grant usage on *.* to "zabbix-monitor"@"%" identified by '123134';mysql> fl

客户端配置监控mysql

数据库授权mysql> grant usage on *.* to "zabbix-monitor"@"%" identified by '123134';mysql> flush privileges;数据库需要用到的key[root@localhost etc]# cp /data/zabbix-2.4.6/conf/zabbix_agentd/userparameter_mysql.conf /usr/local/zabbix-2.4.6/etc/zabbix_agentd.conf.d/vim /usr/local/zabbix-2.4.6/etc/zabbix_agentd.conf# Include=/usr/local/etc/zabbix_agentd.conf.d/*.conf建立数据库和zabbix的链接关系[root@localhost ~]# vim /usr/local/zabbix-2.4.6/etc/.my.cnf#Zabbix Agent[mysql]host=localhostuser=zabbix-monitorpassword=123456socket= /tmp/mysql.sock[mysqladmin]host=localhostuser=zabbix-monitorpassword=123456socket= /tmp/mysql.sockvim /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf将HOME=/var/lib/zabbix全部改成HOME=/usr/local/zabbix/etc/

检索mysql信息时发现sh: mysql: command not found

这一般是路径不对。修改文件zabbix_agentd.conf.d/userparameter_mysql.conf

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/usr/local/zabbix/etc /usr/local/mysql/bin/mysql -N | awk '{print $$2}'

zabbix和mysql，都要用绝对路径，其中zabbix给到./my.cnf的家目录即可。

ps可以自己修改获取到正确的参数例如：UserParameter=mysql.version,/usr/local/mysql/bin/mysql -V|awk '{print $2,$3,$4,$5}'

客户端zabbix_agentd.conf文件修改重启后，信息还没更新过来，此时重启一下服务端就ok了。