phpmyadmin

compose.yml

services:
  phpmyadmin:
    image: phpmyadmin/phpmyadmin:5.2
    container_name: phpmyadmin
    environment:
      PMA_HOST: db
      PMA_PORT: 3306
      PMA_ARBITRARY: 0
    depends_on:
      - db
    networks:
      - app_network
      - web
    labels:
      - "traefik.enable=true"
      - "traefik.docker.network=web"
      - "traefik.http.routers.pma.rule=Host(`pma.example.com`)"
      - "traefik.http.routers.pma.tls.certresolver=letsencrypt"
      - "traefik.http.routers.pma.entrypoints=http,https"
      - "traefik.http.routers.pma.middlewares=traefik-auth"
      - "traefik.http.services.pma.loadbalancer.server.port=80"

  db:
    image: mysql:8.1
    container_name: mysql_db
    environment:
      MYSQL_ROOT_PASSWORD: PASSWORD
      MYSQL_DATABASE: DATABASE
      MYSQL_USER: USER
      MYSQL_PASSWORD: PASSWORD
    volumes:
      - ./dbbackup.sql:/docker-entrypoint-initdb.d/dbbackup.sql
      #- mysql_data:/var/lib/mysql
    #ports:
    #  - "127.0.0.1:3307:3306"
    networks:
      - app_network

#volumes:
#  mysql_data:

networks:
  app_network:
  web:
    external: true