Cannot Connect to MySQL DB

Grafana MySQL
,
1

Hello there,

I install Grafana in a windows server and it refuse to connect to the db server which have MySQL db installed in port 3306. Grafana gives the error shown in the image.

grafanaError
grafanaError1603×970 57.5 KB

And iam sure the connection between the two servers (grafana server and MySQL db server) is fine, i check the firewall and everything.
I dont know why it is not connecting.

Also I want to mention that i am able to connect with MS SQL server the same way, this issue happens only with MySQL db, I try three different servers that have MySQL db, non of them worked and the same error appear.

2

Hi @loay96azri,

Welcome to the :grafana: community support forums !!

I think you might be either missing the privileges or firewall port forwarding.

Please check this link as it list some good example to tackle such issues.

I hope this helps.

3

Welcome

What do you have for your settings in the following section of mysql for grafanareader?

image
image868×361 46.4 KB

4

Thank you very much,
I find the solution in the link you sent.
I just needed to execute the following command in MySQL to allow the connection from the Grafana Server.

CREATE USER ‘grafana’@‘IP-Address’ IDENTIFIED BY ‘password’;
GRANT SELECT ON my2.* TO ‘grafana’@‘IP-Address’;
FLUSH PRIVILEGES;
quit