Authentication method 'caching_sha2_password' not supported by any of the available plugins

Question

When I try to connect MySQL (8.0) database with Visual Studio 2018 I get this error message

"Authentication method 'caching_sha2_password' not supported by any of the available plugins"

Also I am unable to retrieve Database name. I use mysql-for-visualstudio-1.2.7 and mysql-connector-net-8.0.11 for connection. Is there any possible way to fix it.

Answer 1

1st

Modify the MySql Server:

1. Open MySQL Installer - Community
2. Select Product MySQL Server
3. Click on Quick configure in last column
4. Click on next untill you will not point to Authentication method
5. On Authentication method tab- select Use Legacy Authentication method
6. Click on next and finish

Now you can login with normal password

2nd

If you are using .net framework 4.5.2 you can easy upgrade reference of MySQL.Data:

1. Visulastudio> Tools> Nuget Package Manager>Manage nuget package for solution
2. Go to Browse tab, Write Search textbox mysql and enter first mysql.data package will come, install it

Now login, issue will resolved

Answer 2

This is a new authentication method used in MySQL version 8.0 as compared to mysql_native_password, which is the legacy method. In order to make this work, you will need to upgrade your MySQL Client library to version 8.0.

So, use the following link and get the version 8.0.11 or higher.

https://dev.mysql.com/downloads/connector/net/