How to fix MySQL: Failed to fetch info data (or no data for 30m) alert-
Step 1- SSH to the server and go to path /etc/zabbix/zabbix_agentd.d and check mysql temple file is present or not. If the file is not present we need to add the template file.
[[email protected] zabbix_agentd.d]# ll
total 0
[[email protected] zabbix_agentd.d]# pwd
/etc/zabbix/zabbix_agentd.d
Step 2- We need to check Zabbix user is able to login in mysql or not. For finding user details we need to go to the path-/etc/zabbix/.my.cnf
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[[email protected] zabbix]# vi .my.cnf
[client]
user=zbx_newmonitor
password=ZjYwOWIyY2Uw
[[email protected] zabbix]# pwd
/etc/zabbix
[[email protected] zabbix]# mysql -u zbx_newmonitor -p
Enter password:
ERROR 1045 (28000): Access denied for user 'zbx_newmonitor'@'localhost' (using password: YES)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Step 3- We need to again create the user in mysql and we need to provide all permissions to that user.
Step 4- Now we have to again try with that user and check if user is able to login or not. If login is successful then the issue is fixed.
Step 5- After that, we have to restart zabbix-agent-
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[[email protected] zabbix]# systemctl restart zabbix-agent
[[email protected] zabbix]#
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++