MySql Caching_Sha2_Password Error

  1. 2 months ago

    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

    creating a new user with standard authentication will solve the issue. I use workbench where its very easy to create.

  2. 4 weeks ago

    creating a new user with standard authentication will solve the issue. I use workbench where its very easy to create.

  3. Christian S

    Aug 27 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    or connect via MBS Xojo SQL Plugin .

or Sign Up to reply!