Mysql: Issues with 8.0.1

[kelchm]

I've not had a chance to dig into this yet, but 8.0.1 seems to be causing issues with a PHP application (Joomla) that I am using. Switching back to 8.0.0 without changing anything else and everything works as expected.

I will provide further details when I have an opportunity to dig into this further.

[ltangvald]

Thanks. Quick question: Is it a fresh install, or are you trying to upgrade a database that was running with 8.0.0?

[kelchm]

@ltangvald, a brand new fresh install. Not using any volumes.

Oddly enough I am able to connect via the console, but my application reports it is not able to connect. Some kind of compatibility issue with mysqli?

[kelchm]

Here is the error that is occurring

Warning: mysqli::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers in /home/src/test.php on line 3
Warning: mysqli::__construct(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in /home/src/test.php on line 3
Connect failed: Server sent charset unknown to the client. Please, report to the developers

[yosifkit]

Probably this:

This release makes several important changes in Unicode character set support. In particular, the default character set has changed from latin1 to utf8mb4.

- https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-1.html

[bscheshirwork]

same problem

bash-4.3# ./yii migrate
Yii Migration Tool (based on Yii v2.0.12-dev)

Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers'

in /var/www/html/vendor/yiisoft/yii2/db/Connection.php:568

I set entrypoint section in my docker-compose.yml

version: '2'
services:
  db:
    image: mysql:8.0.1
    entrypoint: ['/entrypoint.sh', '--character-set-server=utf8', '--collation-server=utf8_general_ci']

[ltangvald]

Hi,

This is a known issue with the php client not handling the changed default in 8.0.1

https://bugs.mysql.com/bug.php?id=85946 contains a discussion, with a link to the php bug report at https://bugs.php.net/bug.php?id=74461 (appears it's been fixed in php's git repo)

[bscheshirwork]

Wait for php:7.1.5

[bkuhl]

PHP:7.1.5 is out

[bkuhl]

This should be closed as it's not a mysql issue.

[mhetreramesh]

Any solution on this issue, I still facing the same issue

[Kuzirashi]

What's the solution to this problem?

[bkuhl]

If you look at the recent comments, you need to use a PHP version greater than 7.1.5.

[Kuzirashi]

Currently using:
PHP 7.1.11-1+ubuntu16.04.1+deb.sury.org+1

[bkuhl]

Sounds like it might be an issue with your applications configuration then.
You will probably want to look at the configured character set.

On Tue, Dec 19, 2017, 4:33 PM Daniel Kmak [e-mail] wrote:

Currently using:
PHP 7.1.11-1+ubuntu16.04.1+deb.sury.org+1

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/docker-library/mysql/issues/284#issuecomment-352892835,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAgChd7_TWq_2Xi0AdSbsAtKCmBUzpWFks5tCCufgaJpZM4M794M
.

>

Ben Kuhl