Problems connecting to MySQL 8.0.4

exporttodatabase

#1

I am trying to connect CP 3.0.0 to a MySQL 8.0.4 database and I get the following error message:

A connection error to the database host was returned: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/Cellar/mysql/5.7.19/lib/plugin/caching_sha2_password.so, 2): image not found. Please check your settings.

Is there a plugin I need to download? Where would I save it?

Thanks!


#2

Hi,

That error is a new one on me- can you tell us a bit more about your setup- what OS, is CP installed as a binary or from source, etc? Is this after using the “test connection to database” button, or when you’re trying to write to it?


#3

I am using the binary install of CP/CPA. This error is after the “test connection to database” button is pressed. The MySQL database is using the new “caching_sha2_password” setting only on the database. I found this on the MySQL website. https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html Which authentication method does CPA use - caching_sha2_password or mysql_native_password?


#4

I’m reasonably certain CP can only use the native one. Sorry!


#5

I’ll see about installing the server-side plugin to see if that works.