MySQL 8 with Docker Compose

compose.yaml

name: mysql

services:
  mysql:
    image: mysql:8
    container_name: mysql
    ports:
      - "3306:3306"
    command:
      [
        "--character-set-server=utf8mb4",
        "--collation-server=utf8mb4_0900_ai_ci",
      ]
    volumes:
      - "mysql_data:/var/lib/mysql"
      - "./custom.cnf:/etc/mysql/conf.d/custom.cnf"
    environment:
      MYSQL_ROOT_PASSWORD: root**pass
      MYSQL_DATABASE: devdb
      MYSQL_USER: user
      MYSQL_PASSWORD: youmayneverguess
    restart: on-failure

  phpmyadmin:
    image: phpmyadmin
    ports:
      - 9000:80
    environment:
      - PMA_HOST=mysql
      - PMA_USER=root
      - PMA_PASSWORD=root**pass
    depends_on:
      - mysql
    restart: on-failure

volumes:
  mysql_data:

custom.cnf

[mysqld]
# Can be 1, 2, 3
log_error_verbosity=1