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.

[root@server16 zabbix_agentd.d]# ll
total 0
[root@server16 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

[root@server16 zabbix]# vi .my.cnf

[root@server16 zabbix]# pwd
[root@server16 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-


[root@server16 zabbix]# systemctl restart zabbix-agent

[root@server16 zabbix]#



Was this article helpful?

mood_bad Dislike 4
mood Like 1
visibility Views: 4809