I hope someone is able to help because I’m just about ready to give up. What I’m Trying to Achieve I’m trying to create a MySQL datasource in Grafana and connect it to a MySQL database. Method I have Grafana 10.3 installed on a Debian 11 server (178.x.x.x) I have MySQL installed on a different …

Hey @yosiasz , thanks for your reply. Yes, I’m using DBeaver which is working quite well. I’ve created a user, specifying the IP address of my Grafana server as shown below: [image] Even after this change, I’m still getting the same connection error.

You don’t need the ip address when creating th3 connection in grafana

[image] yosiasz: CREATE USER ‘sammy’@‘grafana_server_ip’ IDENTIFIED Did you do this bit in mysql

[image] yosiasz: Did you do this bit in mysql Yes, I did that.

[image] yosiasz: You don’t need the ip address when creating th3 connection in grafana I’ve tried it with and without. It doesn’t connect either way.

I’m using DBeaver to create users and set privileges. The only privilege I’ve set for the grafana user is SELECT on the zoho_invoice table. [image]

It seems all looks fine. Not sure what the issue is :man_shrugging:t5: And can you show us how the user was setup in that screen minus ip Also you did restart the mysql service for the bind address change? Are they both in same ip network? Is tls enabled on mysql

Hi, Did you restart the mysql service after changing the bind address? sudo systemctl restart mysql # for ubuntu sudo systemctl restart mysqld.service # for debian Did you create a new user or grant permissions to an existing user to connect from the remote IP? GRANT ALL PRIVILEGES ON yourDB.* T…

[image] sowdenraymond: Did you restart the mysql service after changing the bind address? Yes. I’ve restarted the service and rebooted the server multiple times. [image] sowdenraymond: Did you create a new user or grant permissions to an existing user to connect from the remote IP? I …

Can't Connect Grafana To MySQL

Grafana MySQL

yosiasz February 14, 2024, 1:59pm 10

Using a visual tool such mysql workbench or other tool, can you visually show us using a screen grab the permissions you setup for this user on that zoho database?

Topic		Replies	Views
How to connect MySQL DataBase with grafana Configuration mysql	20	27968	July 4, 2021
Cannot Connect to MySQL DB MySQL mysql , datasource	3	2333	November 19, 2022
How to connect MySql with Grafana MySQL mysql , config-help , datasource	5	1382	November 17, 2022
MySQL connection fail MySQL mysql	17	11717	December 19, 2018
Cant connect to mysql MySQL mysql	2	2651	May 10, 2019

Can't Connect Grafana To MySQL

Related topics