# mysql设置密码为123
[root@\ db02/etc/zabbix/zabbix_agentd.d]# mysqladmin -uroot password '123'
Warning: Using a password on the command line interface can be insecure.
[root@\ db02/etc/zabbix/zabbix_agentd.d]# mysql -uroot -p123
#修改agent的默认监控mysql的配置
[root@\ db02~]# cd /etc/zabbix/zabbix_agentd.d/
[root@\ db02/etc/zabbix/zabbix_agentd.d]# vim userparameter_mysql.conf
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -uroot -p123 -N | awk '{print $$2}'
HOME=/var/lib/zabbix mysql -uroot -p123 -N'
UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin -uroot -p123 ping | grep -c alive
UserParameter=mysql.version,mysql -uroot -p123 -V
# 加上数据库的用户和密码
[root@\ db02/etc/zabbix/zabbix_agentd.d]# systemctl restart zabbix-agent.service