Can't use empty password for mysql data source

Grafana
1

Hi,
I am new to Grafana, and I would like to create a dashboard of the public data available in the Ensembl public MySQL services

These databases are accessible at hostname: ensembldb.ensembl.org with user: anonymous and no password. However when I try to provide a blank password as credentials, I get the error ‘‘anonymous’@‘hh-bigip-ve3905.ebi.ac.uk’ (using password: YES)’

Any suggestions?
Thanks

2

Hi,

Interesting. Could you please create an issue for this at Grafana Github repository? Thanks

Marcus

3

Hi. Did someone have a workaround on this? I’m also new in Grafana and tried this public database ensembldb. I do not have a database to try on Grafana. I prefer to try some public database (with data already) to familiarize in Grafana UI and querying.

4

Hi, @tomhodder - FYI I get that same response when trying to connect directly to that host using mysql client from the command-line, so I suspect this is not a Grafana issue.

Did you ever resolve this connection problem? I’m stumped.

Cheers

5

FWIW: I figured out my issue and I bet it is your too.

In my case, I happened to have created a mysql configuration file, ~/.my.conf, which provided a default password for ALL connections. This was a bad idea ©. Removing it allowed the connection to proceed.