search

wodby / php

Generic PHP docker container images
MIT License
155 stars 103 forks source link

caching_sha2_password.so library not found #122

Closed beltofte closed 3 years ago

beltofte commented 4 years ago

When using the Wodby PHP container and trying to connect to a MySQL 8 container / service using the mysql cli command ( mariadb-client) is it failing due to caching_sha2_password.so library not found. The full error message is:

_wodby@php.container:/var/www/html $ mysql -u php -p -h mysql Enter password: ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2password.so: No such file or directory

Suggestion: add the MariaDB caching_sha2_password to the container.

The only temporary solution I found is to switch the MySQL 8 container / service to use 'mysql_native_password' as default authentication plugin.

csandanov commented 4 years ago

Could you try latest image, I've added mariadb-connector-c that contains caching_sha2_password.so