zabbix监控mysql-muzinan的技术博客
默认mysql监控模版安装方法：vim /usr/local/etc/zabbix_agentd.conf
UserParameter=mysql.ping,mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V
UserParameter=mysql.status
[*],echo "show global status where Variable_name='$1';" | mysql -N -uroot | awk '{print $$2}'
UserParameter=mysql.ping,/usr/local/mysql/bin/mysqladmin ping | grep -c alive
UserParameter=mysql.version,/usr/local/mysql/bin/mysql -V
UserParameter=mysql.status
[*],echo "show global status where Variable_name='$1';" | /usr/local/mysql/bin/mysql -N -uroot | awk '{print $$2}'
pkillzabbix
service zabbix_agentd start
默认的模版用的是mysqladmin 命令 启动mysql时，默认空密码，之后再改mysql的密码导致mysqladmin不能使用
报错：
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
改回原来空密码即可
页:
[1]