Authentication method caching_sha2_password
not supported by any of the available plugins.
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
I solved the problem by updating .NET FRAMEWORK target value to 4.5.2