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!