The CentOS 7 / MySQL 8 docker compose project sets --default-authentication-plugin=mysql_native_password so that setup for the 4.3.0 server succeeds. Without this option, setup fails with the following message:
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
We need to investigate whether other OS / MySQL 8 compose projects need this option as well.
[ ] Rocky Linux 8
Investigation
The CentOS 7 / MySQL 8 docker compose project sets
--default-authentication-plugin=mysql_native_passwordso that setup for the 4.3.0 server succeeds. Without this option, setup fails with the following message:We need to investigate whether other OS / MySQL 8 compose projects need this option as well.