docker-compose php-7-with-mysql

docker-compose.yml

version: "3.1"
services:
  mysql:
    image: mysql:5.7
    container_name: oneprojectday-mysql
    working_dir: /application
    volumes:
      - .:/application
    environment:
      - MYSQL_ROOT_PASSWORD=secret
      - MYSQL_DATABASE=my_app
      - MYSQL_USER=my_app
      - MYSQL_PASSWORD=secret
    command: mysqld --sql_mode="NO_ENGINE_SUBSTITUTION" --character-set-server=utf8 --collation-server=utf8_general_ci --init-connect='SET NAMES UTF8;' --innodb-flush-log-at-trx-commit=0
    ports:
      - "3306:3306"
  php-fpm:
    image: webdevops/php-nginx:7.4
    container_name: oneprojectday-webserver
    working_dir: /app
    volumes:
      - ./11-tasks/:/app
    environment:
      - WEB_DOCUMENT_ROOT=/app/webroot
      - DATABASE_URL=mysql://my_app:secret@mysql/my_app?encoding=utf8&timezone=UTC&cacheMetadata=true
    ports:
      - "80:80"
      - "443:443"