How do I resolve mysqlexception: authentication method 'caching_sha2_password' not supported by any of the available plugins in visual studio 2017

Question

0.00/5 (No votes)

See more:

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

Posted 9-May-18 20:19pm

Ger Hayden

Updated 10-May-18 7:13am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ger Hayden · Answer 1 · 2018-05-10T07:14:00

Solution 1

The solution is to add

persistsecurityinfo=True;

to the connection string.

Posted 10-May-18 7:14am

Ger Hayden

Sameer Bahad · Answer 2 · 2019-02-13T18:14:00

[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