Docker MySQL example

docker-compose.yml

version: '3'

services:

  mysql:
    image: mysql:5.7
    restart: on-failure
    environment:
      TZ: Asia/Tokyo
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: db_local
      MYSQL_USER: docker
      MYSQL_PASSWORD: docker
    ports:
      - 3306:3306
    volumes:
      - database:/var/lib/mysql
#      - ./sql:/docker-entrypoint-initdb.d:ro
    command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    restart: on-failure
    environment:
      PMA_ARBITRARY: 1
      PMA_HOST: mysql
      PMA_USER: docker
      PMA_PASSWORD: docker
    ports:
      - 8080:80
    depends_on:
      - mysql

volumes:
  database: