How to monitor a MySQL database from Zabbix via OCBC - Zabbix 6.0.32

[adavidus]

I've been trying to connect to a MySQL database and I've used the MySQL and MariaDB drivers, through the MySQL driver and without having certificates it allows me to connect without problem with isql -v and the DSN name, now when I try to use the connection from Zabbix using that same DSN it generates...

[nmz]

I'm using zabbix server 2.2 and database and zabbix_agent was installed in other host. When I try to monitor mysql database with zabbix agent I got such as error
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'...

[appope]

the details log is here ：
zabbix_sender [4325]: DEBUG: send value error: gethostbyname() failed for 'Server=192.168.1.196': [3] Unknown server error
zabbix_sender [4327]: DEBUG: send value error: gethostbyname() failed for 'Server=192.168.1.196': [3] Unknown server error
...