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
/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

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root@server16 zabbix]# vi .my.cnf
[client]
user=zbx_newmonitor
password=************

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