1.GUI界面添加Mysql模板
Configuration --> Hosts --> 点击要添加的主机 --> Templates
添加新的模板,点击Select -->选择”Template DB MySQL“
点击“add”添加,最后点击Update更新;
2.登陆MySQL服务,创建只读账户;
mysql> grant select on *.* to "zabbix"@"localhost" identified by “123456”; #赋权
mysql> flush privileges; #刷新权限
3.修改mysql服务器的agent配置
# cd /etc/zabbix/zabbix_agentd.d
# cp userparameter_mysql.conf{,.bak}
# vim userparameter_mysql.conf
5 UserParameter=mysql.status[*],echo "show global status where Variable_name=