Zabbix-Agent 5.0 monitor MySQL database on a Linux Ubuntu 20.04!

Hello everyone in today’s tutorial I will explain to you how to monitor your database on a linux host, for this example, I will monitor my database mysql on the zabbix server(localhost).

1. Create MySQL user for monitoring. Type mysql in your terminal on a linux host, than enter the next commands:

a)CREATE USER ‘zbx_monitor’@’%’ IDENTIFIED BY ‘zabbix’;

b) GRANT ALL PRIVILEGES ON *.* TO ‘zbx_monitor’@’%’;

c) FLUSH PRIVILEGES;

d)quit

2. Create .my.cnf in home directory of Zabbix agent for Linux (/var/lib/zabbix by default ) if you don’t have a folder zabbix in /var/lib/ than create one with command mkdir zabbix

a) nano .my.cnf and in nano file type same as I have on 08:30

3. Locate your userparameters.conf file and copy it into /etc/zabbix/zabbix_agentd.d/ and remove it from the previus location.

4. Type in terminal systemctl restart zabbix-agent

5. Wait a few minutes and check your parameters on zabbix server in the menu monitoring-latest data.

Thank you, and please subscribe!