MySql Caching_Sha2_Password Error

  1. last week

    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

    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

or Sign Up to reply!