Server sent charset unknown to the client about wordpress-docker-compose HOT 3 CLOSED

Hi @borisdiakur

Thanks for bringing this to my attention :). I think your fix would be ok in most cases.
To change the charset it requires some extra configurations: https://hub.docker.com/_/mysql/ (see Configuration without a cnf file)

On my machine I got an error regarding the authentication to the db. So I will also include the option to revert to the mysql_native_password plugin for authentication in the docker-compose.yml

  db:
    image: mysql:5.7
    ports:
      - 127.0.0.1:3306:3306 # change ip if required
    command: [
        '--default_authentication_plugin=mysql_native_password',
        '--character-set-server=utf8mb4',
        '--collation-server=utf8mb4_unicode_ci'
    ]
    volumes:
      - ./wp-data:/docker-entrypoint-initdb.d
    environment:
      MYSQL_DATABASE: wordpress
      MYSQL_ROOT_PASSWORD: password
    networks:
      - wordpress-network

This works for latest (8.0), 5.7 and 5.6

from wordpress-docker-compose.

Fixed it in the docker-compose.yaml by changing

db:
    image: latest

to

db:
    image: mysql:5.7

The issue seems to be that MySQL 8 changed the default charset to utfmb4. Is there maybe a better solution than sticking to mysql 5.7?

from wordpress-docker-compose.

thank you!

from wordpress-docker-compose.