c# - 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