New MySQL datasource connection through Grafana server

Hi,
I am running a scenes app on WSL2 and wanted to connect to a MySQL server on my windows system (same device). I was trying to do this through the grafana server but i’m unable to connect to the sql server. I tried replacing localhost with the windows ip address and the wsl vEthernet ip address; and I tried changing the firewall settings as well, but nothing seems to work. The error log shows “failed to authenticate request” but I’m sure I’m using the correct user credentials. What might be the issue?

Thanks in advance!

Please post your scene code. is mysql installed raw on your windows machine or as a docker instance

Thanks for reaching out. MySQL is installed raw on my windows machine. I was trying to add a new connection through the grafana server’s “Connections” page, so I haven’t declared any variable or queryrunner in my plugin code.

1 Like

Does the user have the permission needed to authenticate? A remote user from same IP address. This seems more of a MySQL authentication issue. Firewall settings?

Might be the case. Cause I had built a grafana dashboard on my windows machine and the connections worked fine. But now that the scenes plugin needs a wsl server, the communication issue arose. I’ll do some further troubleshooting. Thank you for your help!

1 Like

check this out

pretty sure it is not a grafana issue