设置授权用户和密码
[root@zabbix-agent-none1 ~]
在末行插入以下内容:
[client]
default-character-set=utf8
host=localhost
user='zabbix'
password='Yuanwei@123'
进入数据库授权用户和密码
[root@zabbix-agent-none1 ~]
Enter password: //密码为Yuanwei@123
mysql> grant all privileges on *.* to zabbix@localhost identified by 'Yuanwei@123';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
agent配置文件打开自定义监控
vim /etc/zabbix/zabbix_agentd.conf
去掉注释
Include=/etc/zabbix/zabbix_agentd.d/*.conf
编辑自定义监控脚本
vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
添加内容
UserParameter=mysql.version,mysql -V | cut -f6 -d" " | sed 's/,//'
UserParameter=mysql.process,ps -ef|grep "mysql"|grep -v "grep"|wc -l
UserParameter=mysql.ping,/usr/bin/mysqladmin ping|grep alive|wc -l
UserParameter=mysql.uptime,/usr/bin/mysqladmin extended-status|grep Uptime|head -1|cut -f3 -d"|"
UserParameter=mysql.Threads.connected,/usr/bin/mysqladmin extended-status|grep Threads_connected|head -1|cut -f3 -d"|"
UserParameter=mysql.Threads.running,/usr/bin/mysqladmin extended-status|grep Threads_running|head -1|cut -f3 -d"|"
UserParameter=mysql.aborted.clients,/usr/bin/mysqladmin extended-status|grep Aborted_clients|head -1|cut -f3 -d"|"
UserParameter=mysql.Slave.status,/usr/bin/mysqladmin extended-status|grep Slave_runnin | grep -o ON |wc -l
UserParameter=mysql.questions,/usr/bin/mysqladmin extended-status | grep Questions | head -1 | cut -f3 -d"|"
UserParameter=mysql.read.rnd,/usr/bin/mysqladmin extended-status|grep Handler_read_rnd_next|head -1 | cut -f3 -d"|"
UserParameter=mysql.write.rnd,/usr/bin/mysqladmin extended-status|grep Handler_write|head -1|cut -f3 -d"|"
UserParameter=mysql.commit,/usr/bin/mysqladmin extended-status|grep Handler_commit| head -1 | cut -f3 -d"|"
UserParameter=mysql.delete,/usr/bin/mysqladmin extended-status|grep Handler_delete| head -1 | cut -f3 -d"|"
UserParameter=mysql.Opened.tables,/usr/bin/mysqladmin extended-status|grep Opened_tables| head -1 | cut -f3 -d"|"
UserParameter=mysql.slowqueries,/usr/bin/mysqladmin extended-status|grep Slow_queries|cut -f3 -d"|"
UserParameter=mysql.select.scan,/usr/bin/mysqladmin extended-status|grep Select_scan|cut -f3 -d"|"
重启agent
systemctl restart zabbix-agent
server端测试是否能拉取到数据
[root@zabbix ~]
1
[root@zabbix ~]
5.7.27
web端添加模板
![在这里插入图片描述](https://img-blog.csdnimg.cn/c12c82cefb3b4ff08bd51c2bd6e70cee.png#pic_center)
添加到主机,查看最新数据
![在这里插入图片描述](https://img-blog.csdnimg.cn/0e55dfe5c49c4d9b87312f056b7fdb64.png#pic_center)