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

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 1860