Question Docker + MySQL 8 - charset error when adding as database server

[cool_sh]

Hi all together,

I sucessfully created a docker container with the current MySQL 8.0.3
But when I try to provide it as a database server for all customers on <your_plesk_url: port>/server/db_server_edit.php the following error occurs:
Server sent charset unknown to the client. Please, report to the developers

As far as I understood the problem is the charset change in MySQL to utf8mb4 which causes the problem. But I have no idea how to fix this. Do I have to change the charset on the mysql-server inside the docker container or is there a way to fix this inside plesk?

Using Plesk Onyx 17.5.3 Update #39 on ‪CentOS Linux 7.4.1708 (Core)‬ with the MySQL-docker-container 8.0.3-rc-1debian8

Regards

 

[IgorG]

Looks like PHP issue, according to Issues with 8.0.1 · Issue #284 · docker-library/mysql · GitHub
Try to use PHP 7.2 version.

 

[cool_sh]

Hallo IgorG,

which PHP version do you mean?
The version plesk uses by himself ob the CentOS installation?

 

[IgorG]

The version plesk uses by himself ob the CentOS installation?

I mean PHP7.2 from Plesk.

 

[cool_sh]

Sorry for questioning again but yould you guide me?
I do not know about how to change the php version plesk uses by himself.

 

[IgorG]

So, please correct me if I'm wrong. You are trying to connect a MySQL 8 installed in the docker, as a MySQL database server in Plesk?
But Plesk doesn't support MySQL 8 version - Software Requirements for Plesk

Database servers and tools:

MySQL 5.1–5.7
MySQL community edition 5.5, 5.6, 5.7
PostgreSQL 8.4–9.5
MariaDB 5.5, 10.0, 10.1