Problems connecting to MySQL 8.0.4

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/, 2): image not found. Please check your settings.

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



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?

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. Which authentication method does CPA use - caching_sha2_password or mysql_native_password?

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

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

You’re going to have a pretty rough time using MySQL 8+ and a binary installation of CellProfiler. The libmysqlclient library version that the MySQLdb Python module is currently compiled against is definitely not 8+ and is unlikely to be in the future. The relationship between the MySQL project and the open source community further exacerbates this.

If you really must use MySQL 8+, and do not want to compile your own MySQLdb module from source with the correct libmysqlclient library version, then you should have a look at the authentication module compatibility options here:

Thanks! I will try the previously stable version of MySQL.