mysqldump: Authentication plugin 'caching_sha2_password' cannot be loaded

[AmazingDreams]

I got an error on mysql 8: mysqldump: Authentication plugin 'caching_sha2_password' cannot be loaded

Probably the only thing that needs to happen is update mysqldump / the image

[lllelll]

try to don't use MULTI_FILES param

[oleynikd]

+1 same error on MySQL 8

[iloveitaly]

@oleynikd @lllelll @AmazingDreams Feel free to submit a PR to fix this issue! Happy to merge & update the dockerfile.

[JoelESvensson]

There seems to be something wrong with the image that's currently on Docker Hub. The /usr/lib/mariadb/plugin is empty for some reason. I tried buidling locally and it has all the required files for authentication, unlike the published one. On of these files being the caching_sha2_password.so that's required for caching_sha2_password auth. Can you try do a rebuild and push it? @iloveitaly I think that should be all that's required to close this issue, now that the Alpine provided mariadb-c-connector supports caching_sha2_password.

[mhuebner]

Also experiencing this issue after update to MySQL 8 (Aurora) and switch of the authentication plugin for the backup user to caching_sha2_password.

@iloveitaly just like @JoelESvensson suggested: I also think a new docker build and pushing the image with an updated tag should be sufficient. Would it be possible for you do this?

[mhuebner]

I recently forked the repository and built a new Docker image, which resolved numerous new dependencies in the process. Now, I have a fresh image running with a virtual Python environment and awscli (v2). Additionally, this image includes a MySQL client that supports the caching_sha2_password authentication method. The backup jobs are running smoothly again.