Hello, I’ve been trying to add a datasource of mysql db from zabbix server. Everything seems to be ok but after testing the connection it throws an error: db query error: driver: bad connection. I have no idea what’s causing the problem and it’s really hard to find a solution on web. Maybe someone could know what’s going on. Thank you in advance.
Hi @shiashia, welcome to the community.
Can you please check the grafana logs under /var/log/grafana/grafana.log for more details about the error message
Is the grafana server ip address allowed on mysql?
This is not a grafana issue but a mysql issue
Thanks @shiashia ,
Yes it could be the following;
1- Firewall issue as MySQL by default uses port 3306 so open it in the firewall.
2- Next is that if the MySQL server is running on a remote machine (i.e. on same machine where your grafana is running) then you need to configure MySQL to allow remote connection.
3- The MySQL user which you are providing as a datasource inside Grafana to connect to MySQL server, should have correct privileges so that it can be able to access data. Please have a look at the following documentation for more information.
Hopefully it will help