bug(mysql): Plugin caching_sha2_password could not be loaded

[ionling]

Error

-> Dump error: mysqldump: Got error: 1045: "Plugin caching_sha2_password could not be loaded:
Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so:
No such file or directory" when trying to connect

Environment

MySQL 8.0 with caching_sha2_password plugin.

caching_sha2_password

From https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html:

caching_sha2_password: Implements SHA-256 authentication (like sha256_password),
but uses caching on the server side for better performance
and has additional features for wider applicability.

Solution

Add mariadb-connector-c package,
which has the file /usr/lib/mariadb/plugin/caching_sha2_password.so.
See https://pkgs.alpinelinux.org/package/edge/main/x86/mariadb-connector-c.

Postscript

Thansks for the issue arey/mysql-client#5.