Grafana 4.6.2 + MySQL DB 8.0

sneha1992 · April 15, 2019, 6:42am

Hi,

I’m trying to add a data source of type MySQL in Grafana and getting the below message.

this user requires mysql native password authentication.

Have created user in MySQL server using the below query.

CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

When I query the list of users, I can see that, this new user is having plugin as mysql_native_password. But not sure why Grafana is still showing that error message.

Can someone please assist.

clanlaw · April 15, 2019, 8:28am

Are you sure the grafana user should be configured with native password? Try it without.

sneha1992 · April 15, 2019, 9:26am

Hi,

I’m trying to add a data source of type MySQL in Grafana and getting the below message.

this authentication plugin is not supported

Have created user in MySQL server using the below query.

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

When I query the list of users, I can see that, this new user is having plugin as caching_sha2_password . But not sure why Grafana is still showing that error message.

Can someone please assist.

clanlaw · April 15, 2019, 9:39am

I wonder if this is related

github.com/go-sql-driver/mysql

Unable to connect to MySQL 8

opened 12:52PM - 20 Apr 18 UTC

closed 06:28PM - 19 May 18 UTC

danmrichards

bug

### Issue description MySQL 8 has now gone into general availability and I am s…eemingly unable to connect to a MySQL 8 instance as I have previously done with 5.x. Lets say for example I have a MySQL instance running locally via Docker like so: ```bash docker run --name some-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -e MYSQL_DATABASE=dbname -d mysql:8 ``` Then I can try to connect to this instance: ### Example code ```go package main import ( "fmt" "database/sql" "os" _ "github.com/go-sql-driver/mysql" ) func main() { db, err := sql.Open("mysql", "root:my-secret-pw@tcp(localhost:3306)/dbname") if err != nil { fmt.Printf("conn fail: %s\n", err) os.Exit(1) } if err = db.Ping(); err != nil { fmt.Printf("ping fail: %s\n", err) os.Exit(1) } fmt.Println("all good") } ``` Of course I would expect this to work and I'd see the `all good` message (which is the case with a 5.7 instance for example). However I see the following: ### Error log ``` ping fail: this authentication plugin is not supported exit status 1 ``` ### Configuration *Driver version (or git SHA):* 3287d94d4c6a48a63e16fffaabf27ab20203af2a *Go version:* run `go version` in your console go version go1.10 darwin/amd64 *Server version:* E.g. MySQL 5.6, MariaDB 10.0.20 8.0.11 *Server OS:* E.g. Debian 8.1 (Jessie), Windows 10 Mac OS 10.12.6

sjabiulla · April 16, 2019, 5:18am

Hey @clanlaw,

We are still getting the same issue. Still got no luck

Any other suggestions ? Or Do we need to downgrade the MySQL Version that we are using !

sjabiulla · April 23, 2019, 5:21am

@mefraimsson

Is MySQL 8 not supported by Grafana 4.6 ?

clanlaw · April 23, 2019, 9:35am

I suggest filing an issue on the github repository. Then you should get an official response.

[Edit] But you should probably check with the latest Grafana first. The developers are unlikely to do anything if it does work with the latest release.

mefraimsson · April 23, 2019, 9:52am

We have an open issue for support MySQL caching_sha2_password for Grafana backend database specifically, see my comment on that issue. But for MySQL datasource the allowNativePasswords=true is set in connectionstring since Grafana v5.0.

sjabiulla · April 24, 2019, 3:43am

Yea, on latest version of Grafana (6.1.4), we are not facing any issue. We are using the latest version and proceeding for now.

Thank you