安装odbc驱动
dnf install unixODBC unixODBC-devel -y
安装mysql驱动
https://dev.mysql.com/downloads/connector/odbc/
dnf install mysql-connector-odbc
查找驱动文件
# rpm -qa|grep mysql-connector-odbc
mysql-connector-odbc-8.3.0-1.el8.x86_64
# rpm -ql mysql-connector-odbc-8.3.0-1.el8.x86_64
/usr/lib64/libmyodbc8a.so
/usr/lib64/libmyodbc8w.so
添加驱动/etc/odbcinst.ini系统默认会添加
[MySQL ODBC 8.3 Unicode Driver]
DRIVER=/usr/lib64/libmyodbc8w.so
UsageCount=1
[MySQL ODBC 8.3 ANSI Driver]
DRIVER=/usr/lib64/libmyodbc8a.so
UsageCount=1
配置链接信息/etc/odbc.ini
[ip地址]
Driver = MySQL ODBC 8.3 Unicode Driver
Server = ip地址
Port = 3306
1,mysql服务器安装zabbix-agent2
修改配置
vim /etc/zabbix/zabbix_agent2.conf
Server=[zabbix-server]
ServerActive=[zabbix-server]
Hostname=[mysql hostname]
2,mysql创建查询用户,授权访问为localhost,因为是本地agent调用。
mysql>CREATE USER 'zabbix_monitor'@'localhost' IDENTIFIED WITH mysql_native_password BY '密 码';
赋予权限
mysql>GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.*
刷新权限
mysql>FLUSH PRIVILEGES;
3,配置MySQL by Zabbix agent 2模板