MySQL: Failed to fetch info data

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

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

[[email protected] zabbix]# pwd
[[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]#


Was this article helpful?

mood_bad Dislike 4
mood Like 0
visibility Views: 2856