Monitoring MySQL zabbix 3

[aredoff]

Hi, I can not adjust the monitor through a standard template "Template App MySQL".
MySQL on Centos.

I use standart userparameter_mysql.conf

Do I need to change :HOME=/var/lib/zabbix ?
Do I need write pass: mysql -N -uroot -ppassword?
Do I need to create the file .my.cnf?
Please help..

[DmitryL]

Hello aredof!

In zabbix-agent.conf look at Include= parameter.
Should be something like Include=/etc/zabbix/zabbix_agentd.d/*.conf
So this is path where userparameter_mysql.conf should be.

In userparameter_mysql.conf HOME= path should be path to .my.cnf file. No need to specify -u / -p
In my case it is HOME=/etc/zabbix/zabbix_agentd.d/

/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

create .my.cnf file with content
[mysql]
password=your password

Make sure that Selinux doesnt block zabbix-agent connection to mysql.
You can turn if off for testing
setenforce 0 and turn it on with setenforce 1