Error 1045: Access denied for user 'root'@'localhost' (using password: YES)

Please help i have a problem on Data Source Mysql

Hi,

The error message hints that Grafana cannot reach a mysql instance running on localhost port 3306. Are you running Grafana locally or Hosted Grafana?

Marcus

hi too,

in local

regard,
alvianno

I would suggest you start with connecting using the MySQL Command-Line Tool. When you got that working, you can continue with the data source in Grafana.

Marcus

i dont hace run grafana-cli.exe

i dont have run grafana-cli.exe

You answered to the wrong thread???

Iam also getting “Error 1045: Access denied for user ‘root’@‘localhost’ (using password: YES)”. Iam able to login/acess mysql from command line and also from other applications where i used mysql.

But unable to access from Grafana. please help me.

I am also getting “Error 1045: Access denied for user ‘root’@‘localhost’
(using password: YES)”.

So, you cannot connect to your local MySQL instance using the MySQL client…

I am able to login/acess mysql from command line

Now I am confused. What does this mean which is different from what you did
above?

Marcus said “I would suggest you start with connecting using the MySQL
Command-Line Tool. When you got that working, you can continue with the data
source in Grafana.” and I agree.

This is not a Grafana problem if you cannot connect to your MySQL server using
the MySQL client.

Please give more details about exactly what you did for the two tests you
reported above, one of which worked and one of which did not.

Regards,

Antony.

Fixed and will be included in 6.5 stable, currently included in 6.5-beta1/nightly builds.