I am working to make the connection with MySQL installed on my PC to the Grafana Cloud.
Since I tried most solutions I could find, I still get the error ‘db query error: failed to connect to server - please inspect grafana server log for detail’.
and in server log ‘lvl=eror msg=“query error” logger=tsdb.mysql err="Error 1044: Access denied for user ‘gr’@’%’ to database ‘el_db’"’
I set the firewall rule (outbound) to let the port (3306) a usable for external access.
I set the privileges on the user with ‘select’ only as Grafana document says.
I can successfully access to the MySQL database with Host:‘IP:port number’ in local grafana.
But when I try to connect MySQL database from Grafana cloud with exact same setting that I used for the local grafana, it gives an error.
Can someone give me a clue what is wrong with the setup?