Hello,
I have the mariaDB, phpmyadmin and Grafana addons installed in home assistant.
In the mariaDB I made a new database and new user that has access to that database. I use a node-red flow to write data to that database and that works fine. Now I would like to use grafana to visualize data from that database, but I’m not able to create a working datasource.
In Grafana I made a MySQL datasource and enter the same info as I did in Node-red:
Host url: 127.0.0.1:3306
Database: energie
User: hassener
Password: thepassword
That works for node-red, but not for Grafana.
When I save and test I get an error:
When I check the log page from the addon I find (between a lot oauth errors) this:
logger=tsdb.mysql t=2024-10-26T07:57:25.014256208+02:00 level=error msg="Query error" err="dial tcp 127.0.0.1:3306: connect: connection refused"
I just don’t understand why, since it is working from node-red.
p.s. I tried adding some more screenshots, but since I’m a new user I’m not allowed to.