Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.5k views
in Technique[技术] by (71.8m points)

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

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.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...