mysqlvisual-studio

How to fix Authentication method caching_sha2_password not supported by any of the available plugins in Visual Studio


Authentication method caching_sha2_password not supported by any of the available plugins. image

How can I fix this? or do I need to use another SQL Server?

I don't know what's the problem if it's the installation of MySQL Server or just the code I'm using, I also added MySQL.Data on the reference still not working.

This is the code:

Imports MySql.Data.MySqlClient

Public Class PIS

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

    cn.ConnectionString = "server=localhost; userid=circuit; password=password; database=pis;"
    cn.Open()
    MsgBox("Connected")
    switchpanel(search)

End Sub

End Class

Solution

  • I solved the problem by updating .NET FRAMEWORK target value to 4.5.2