I am trying to test the mysql connection. however, getting following error “Authentication plugin ‘caching_sha2_password’ cannot be loaded. The specific module caould not be found”. I have mysql 8.0 installed. What going wrong here? TIA
[code]mDb = New MySQLCommunityServer
mDb.Host = “127.0.0.1”
mDb.UserName = “root”
mDb.Password = “1234”
mDb.DatabaseName = “testdb”
If mDb.Connect Then
mIsConnected = True
ConnectStatusLabel.Text = “Connected to MySQL”
Else
mIsConnected = False
MsgBox( "Error connecting to MySQL: " + mDb.ErrorMessage)
End If[/code]