grafana 8.0.3, Linux 18.04 LTS (in docker), DB: mariaDB(MySQL)
Would like to connect to the db to test connectivity. When I try to connect the db, it is not giving error in connectivity, but with status as ‘Testing …’ continuing forever, without actually ‘connecting’ to the db.
Steps to reproduce the problem:
- open grafana in a google chrome browser
- login with admin and my-password
- Name : grafana, host: localhost:3000, User grafana, Password (same as db)
(in the grafana browser)
I have edited the /etc/grafana/grafana.ini - the server part as below:
type = mysql
host = 127.0.0.1:3000
name = grafana
user = grafana
password = my-password-for-the-db
Here one point I should mention. I have found that ‘;’ is used as comment-out, so I should remove it to make the editing effective. But if I remove the ‘;’ (semi-colon) I can not start grafana (failing). Means it is considering as an error. On the other hand, when I check the log (/var/log/grafana.log), even though I have changed the ‘type’ from ‘splite3’ to ‘mysql’, but it is still showing ‘splite3’.
So even though it is reading this ‘grafana.ini’ file, and reacting to the syntax error, but it is not actually taking any effect. At least it seems so to me.
How to solve the issue? I am very new to grafana. Just started to use it installing.
May be the connection is something different issue, not directly related to grafana. But at first would like to solve the config file problem.
Any help/tips would be very helpful.