1.在mysql库里创建用户并给权限
a.mysql -u root -p
#创建zabbixmonitor用户给USAGE,SELECT等权限，密码12345，可以用localhost登录
b.GRANT USAGE,SELECT ON *.* TO 'zabbixmonitor'@'localhost' IDENTIFIED BY '123456';
c.flush privileges; #立即刷新权限
2.找到zabbix-agent自带的配置文件
a.locate userparameter_mysql.conf
b.mkdir /var/lib/zabbix;vim /var/lib/zabbix/.my.cnf
[client]
host = localhost
user = zabbixmonitor
passwd = 123456
c.重启zabbix-agent
4.客户端安装的是zabbix-agent的选择 模版1Template DB MySQL,界面看最新数据
另外一种：
1.客户端安装的是zabbix-agent2的选择模版Template DB MySQL by zabbix agent2
创建的mysql用户权限有区别第一步
b.GRANT USAGE,SELECT,PROCESS,SUPER,REPLICATION CLIENT,SHOW DATABSES,SHOW VIEW ON *.* TO 'zabbixmonitor'@'localhost' IDENTIFIED BY '123456';
b1.给所有权限
GRANT all privileges ON *.* TO 'zabbixmonitor'@'localhost' IDENTIFIED BY '123456';
c.flush privileges;
d.重启zabbix-agent2
e. 界面模版里面宏-继承模版的宏配置。
{$MYSQL.DSN} tcp://localhost:3306
{$MYSQL.USER} zabbixmonitor
{$MYSQL.passwd} 123456
f.更新后去最新数据看
注意：mysql端口不是3306的都需要去界面模版上改
