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.