MySQLnd Version

[IZSkiSurfer]

I tried to connect to a MySQL 8 cluster using shinsenter/php:5.6-fpm-apache.
Unfortunately it fails with: "Server sent charset (255) unknown to the client."
The PHP version in the docker image is using mysqlnd 5.0.11-dev which isn't compatible with mysql 8 server's default config.
Is there any chance you can offer a Docker(file) that uses mysqlnd 5.1? Afaik it's the latest version and compatible with mysql 8 server's changed default encoding.

[IZSkiSurfer]

I think I found a solution but as it might me interesting for others a note somewhere or maybe an additional build would be nice.
The trick is to reconfigure and install the mysql extentions with the libmysqlclient installed because the mysqlnd used in the version is not compatible with mysql 8 servers in their default configuration.

You can/should omit the eatmydata usage and it's important to run phpaddmod for at least one module (those are the ones I wanted additionally) before the docker-php-configure lines, otherwise you would need to load the PHP source manually.

FROM shinsenter/php:5.6-fpm-apache

RUN phpaddmod ldap soap memcache odbc pdo_odbc xmlrpc xsl

RUN apt-get update && apt-get install -y eatmydata

ENV LD_PRELOAD libeatmydata.so

# Install MySQL client libraries
RUN apt-get install -y \
    default-libmysqlclient-dev \
    mysql-client \
    build-essential \
	autoconf

RUN docker-php-ext-configure mysqli --with-mysqli=/usr/bin/mysql_config
RUN docker-php-ext-configure pdo_mysql --with-pdo-mysql=/usr/bin/mysql_config
RUN docker-php-ext-configure mysql --with-mysql=/usr
RUN docker-php-ext-install mysql mysqli pdo_mysql
RUN docker-php-ext-enable mysql mysqli pdo_mysql

# Clean up
RUN docker-php-source delete \
    && apt-get purge -y build-essential autoconf \
    && apt-get autoremove -y \
    && rm -rf /var/lib/apt/lists/*

[shinsenter]

@IZSkiSurfer
Hello, and thanks for the information you shared. However, I don't plan to fix issues specific to outdated PHP versions like 5.6, which has already reached its end of life.

I appreciate the solution you provided, as it'll likely be helpful and referenced by others facing the same issue.