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

Question

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

Answer 1

My reputation is too low to add as comment. Here a similar problem faced by other user.

Authentication plugin 'caching_sha2_password' cannot be loaded