mysql异常插件,如何解决mysqlexception：Visual Studio 2017中任何可用插件都不支持身份验证方法'caching_sha2_password'...

I had to do a reinstall of all my software yesterday including the latest MySql - machine failure.

I have a .NET Core app failing with:MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins.

This is my connection string:

{

"Data": {

"MyApp": {

"ConnectionString": "server=localhost;userid=myappUser;pwd=myapppwd;port=3306;database=myappdatabase;sslmode=none"

}

}

}

The only usefull suggestion I can find online is to set authentication to legacy and I also have the choice of reverting to a previous version of MySql.

But they are backward steps. How do I resolve this?

What I have tried:

So far my efforts are restricted to searching for example connection strings

解决方案

The solution is to add persistsecurityinfo=True; to the connection string.

[Resolved]

1st

Way modify the MySql Server Steps Open MySQL Installer - Community Select Product MySQL Server Click on Quick configure in last column

Click on next untill you will not point to Authentication method On Authentication method tab- select Use Legacy Authentication method 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 Steps Visulastudio> Tools> Nuget Package Manager>Manage nuget package for solution Go to Browse tab, Write Search textbox mysql and enter first mysql.data package will come, install it

Now login issue will resolved