登录MySQL,创建一个授权用户
mysql -uroot -ppassword
> grant usage, process, replication client on *.* to 'zbx'@'localhost' identified by 'xxxxxxxxxx;
** xxxxxxx是zbx用户的密码。**
- 编辑配置文件
vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
- 创建目录mkdir /var/lib/zabbix
- 在上面的目录里创建一个文件.my.cnf
vi /var/lib/zabbix/.my.cnf #如下内容
[mysql]
host=localhost
user=zbx
password='xxxxxxxxxx'
socket=/tmp/mysql.sock
[mysqladmin]
host=localhost
user=zbx
password='xxxxxxxxxx'
socket=/tmp/mysql.sock
- 重启zabbix-agent服务
systemctl restart zabbix-agent
- 测试
zabbix_get -s 127.0.0.1 -p 10050 -k mysql.ping
若提示:sh: mysqladmin: 未找到命令
需要: ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/
zabbix_get -s 127.0.0.1 -p 10050 -k mysql.version
zabbix_get -s 127.0.0.1 -p 10050 -k mysql.size
- 去zabbixweb UI界面添加模板
Configuration -> Hosts -> Create host
Agent interfaces -> 127.0.0.1 10050
Templates -> Select -> Template DB MySQL -> select -> Add
Add