zabbix6.4自带模板监控mysql

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

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

2. 创建用于监视的 MySQL 用户

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

3. 配置

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

4. 测试（监控指标已支持）

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