6.4添加自带的mysql模板报错，显示不支持

1
2
Preprocessing failed for: Cannot fetch data: Error 1045: Access denied for user 'root'@'172.20.0.1' (using password: NO).
1. Failed: cannot extract value from json by path "$.Aborted_connects": cannot convert value to string

upload successful

创建用于监视的 MySQL 用户

1
2
CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';

配置

模板–》MySQL by Zabbix agent 2 –》宏（输入对应的用户、密码、主机）

upload successful

测试（监控指标已支持）

随便找一个mysql监控项测试看下有没有数据，可以看到获取数据正常

upload successful