Mysql template fail on Plesk Odin. ZABBIX 4

[akarim]

I have 50 servers monitored for MySQL using the mysql template.

However, when I went to monitor a Plesk Odin server for the first time, it failed me.

I think it's because of the mysqladmin.

This is my conf in all Cpanel servers and work.

/etc/zabbix/.my.cnf

[mysql]
host=localhost
user=zabbix_admin
password=mypassword
socket=/var/lib/mysql/mysql.sock
[mysqladmin]
host=localhost
user=zabbix_admin
password=mypassword
socket=/var/lib/mysql/mysql.sock

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

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/etc/zabbix mysql -N | awk '{print $$2}'
UserParameter=mysql.ping,HOME=/etc/zabbix mysqladmin ping|grep alive|wc -l
UserParameter=mysql.version,mysql -V

/etc/zabbix/zabbix_agentd.conf

...
Include=/etc/zabbix/zabbix_agentd.d/*.conf
...

Error on mysql status (mysql.ping)

Value "mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
0" of type "string" is not suitable for value type "Numeric (unsigned)"

mysql.status[Slow_queries]

Value "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)" of type "string" is not suitable for value type "Numeric (unsigned)"

[diegofeijo]

Try changing /etc/zabbix/.my.cnf to:

[[B]client[/B]]
user=zabbix_admin
password=mypassword