compose.yaml

services:
  mysql8:
    image: mysql:8
    container_name: sqls_mysql8
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: world
      # MYSQL_USER: docker
      # MYSQL_PASSWORD: docker
      TZ: "Asia/Tokyo"
    command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    volumes:
      - mysql:/var/lib/mysql8
    ports:
      - 13307:3306
  # mysql57:
  #   image: mysql:5.7
  #   container_name: sqls_mysql57
  #   environment:
  #     MYSQL_ROOT_PASSWORD: root
  #     MYSQL_DATABASE: world
  #     MYSQL_USER: docker
  #     MYSQL_PASSWORD: docker
  #     TZ: "Asia/Tokyo"
  #   command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
  #   volumes:
  #     - mysql:/var/lib/mysql57
  #   ports:
  #     - 13306:3306
  # mysql56:
  #   image: mysql:5.6
  #   container_name: sqls_mysql56
  #   environment:
  #     MYSQL_ROOT_PASSWORD: root
  #     MYSQL_DATABASE: world
  #     MYSQL_USER: docker
  #     MYSQL_PASSWORD: docker
  #     TZ: "Asia/Tokyo"
  #   command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
  #   volumes:
  #     - mysql:/var/lib/mysql56
  #   ports:
  #     - 13305:3306
  postgres12:
    image: postgres:12-alpine
    container_name: sqls_postgres12
    ports:
      - "15432:5432"
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=mysecretpassword1234
      - PGPASSWORD=mysecretpassword1234
      - POSTGRES_DB=todos
      - DATABASE_HOST=localhost
    volumes:
      - postgres:/var/lib/postgresql/data
  mssql2019:
    image: mcr.microsoft.com/mssql/server:2019-latest
    container_name: sqls_mssql2019
    ports:
      - "11433:1433"
    environment:
      SA_PASSWORD: Passw0rd
      ACCEPT_EULA: Y
    volumes:
      - mssql:/var/opt/mssql/data
volumes:
  mysql:
  postgres:
  mssql: