Zabbix server 5.2.+MariaDB10.5 template_db_mysql.conf doesn´t work Windows server2019

[Matiazz]

Hi everyone

I have troubles with template_db_mysql.conf.

I put inside

UserParameter=mysql.ping[*], mysqladmin -h"$1" -P"$2" ping
UserParameter=mysql.get_status_variables[*], mysql -h"$1" -P"$2" -sNX -e "show global status"
UserParameter=mysql.version[*], mysqladmin -s -h"$1" -P"$2" version
UserParameter=mysql.db.discovery[*], mysql -h"$1" -P"$2" -sN -e "show databases"
UserParameter=mysql.dbsize[*], mysql -h"$1" -P"$2" -sN -e "SELECT COALESCE(SUM(DATA_LENGTH + INDEX_LENGTH),0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"
UserParameter=mysql.replication.discovery[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"
UserParameter=mysql.slave_status[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"

but in source is also information that I should

#For OS Windows: You need add PATH to mysql and mysqladmin and create my.cnf

in my case my.cnf is in C:\my.cnf
with :

[mysql]

user=zbx_monitor
password=zbxmonitorpass
host=localhost

[mysqladmin]

user=zbx_monitor
password=zbxmonitorpass
host=localhost

and It doesn´t work.

Can somebody say how should I add PATH to mysql and mysqladmin beacuse of I think that the problem is there or you see any other ? And where should be file location for template_db_mysql.conf. In my case I put it to C:\Program Files\Zabbix Agent because of I have there also zabbix_agentd.conf but I don´t modify zabbix_agentd.conf.

For other templates is everything fine on machine.

Thank you all

Zabbix server 5.2.Obetal+MariaDB10.5 template_db_mysql.conf doesn´t work on Windows server 2019