Grafana login through external Raspberry Pi MySQL Database

Grafana Configuration
1

Hey Guys,

I am running a raspberry pi with mariadb as a database (mySQL) and to access the database I use phpmyadmin. When I try to login it gives me “db query error”. My grafana is on my windows PC.

The MySQL Connection details
Host: “raspberry pi ip”:3306
Database: Name of the Database indicated in phpmyadmin
User: “phpmyadmin user”
Password: “phpmyadmin pw”

I’m assuming because I am using the host as the ip address of the raspberry pi it should work.

2

Hello :wave: and welcome to the forum, @martinlym

Are you using MySQL as the backend database for Grafana itself (in replacement of the default SQLite) or are you using MySQL as an external datasource plugin? Have you followed the documentation to integrate a MySQL database?