MySql Caching_Sha2_Password Error

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]

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

or connect via MBS Xojo SQL Plugin.