• CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Topic: MySQL authentication error

I have MySQL version 8.0.21 and the server is running. 


When I try via the Connect wizard in MVD to find and connect to a database I get the MySQL error "#08004 Client does not support authentication protocol".

I'm using  Localhost, port 3306, user = root and password = my_password and yet I keep getting a connection error.

I've reset my password but that makes no difference. MySQL is functioning as I have created and used a couple of databases with Workbench.


What might I be missing?

On a clear disk you can seek forever
  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Re: MySQL authentication error

I have discovered the answer!  - MVD does not work with  authentication type "caching_sha2_password"  only with the older style "standard" authentication.

On a clear disk you can seek forever