MySQL CI builds fail due to upgrade to 8.0
Example failing build: https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/64151899
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
We use the mysql:latest
Docker image, and it looks like MySQL just updated to 8.0:
- https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
- https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
- https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/
We should either downgrade to the previous image or set the MySQL server configuration to use default_authentication_plugin=mysql_native_password
.
Edited by Stan Hu