- 新建一个授权的监控用户
grant usage, process, replication client on *.* to 'monitor'@'localhost' identified by 'monitor';
- 修改配置文件
[root@linux2019 ~]# vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf #查看存储授权用户信息的文件路径
[root@linux2019 ~]# mkdir /var/lib/zabbix
[root@linux2019 ~]# vim /var/lib/zabbix/.my.cnf #如下内容
[mysql]
host=localhost
user=monitor
password='monitor'
socket=/tmp/mysql.sock
[mysqladmin]
host=localhost
user=monitor
password='monitor'
socket=/tmp/mysql.sock
[root@linux2019 ~]# systemctl restart zabbix-agent
- zabbix-server端测试
[root@linux2019 bin]# zabbix_get -s 127.0.0.1 -p 10050 -k mysql.ping
sh: mysqladmin: 未找到命令
#环境变量问题
[root@linux2019 bin]# ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/
[root@linux2019 bin]# ln -s /usr/local/mysql/bi