Requirements for MySQL by ODBC template

Overview

This section contains the required steps to ensure proper operation of Template DB MySQL by ODBC, developed for monitoring DBMS MySQL and its forks (such as MariaDB, etc.) by ODBC. (If Zabbix agent is installed on the host and will perform monitoring, see requirements for the MySQL by Zabbix agent template instead.)

Steps

1. Create MySQL user for monitoring (choose your own <password>). For example:

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
       GRANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';

For more information, please see MYSQL documentation.

2. Set the user name and password in host macros ({$MYSQL.USER} and {$MYSQL.PASSWORD}).

3. Import template_db_mysql_odbc.xml (found in the templates directory of the latest Zabbix version or Zabbix Git repository) into Zabbix and link it to the target host.