services:
  mysql:
    container_name: database_server
    image: mysql:latest
    ports:
      - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: StrongRootPass123  # MySQL 的根密碼
      MYSQL_DATABASE: production_db           # 要建立的資料庫名稱
      MYSQL_USER: db_user                     # 新使用者的名稱
      MYSQL_PASSWORD: UserPass456             # 新使用者的密碼
    volumes:
      - ./my.cnf:/etc/mysql/conf.d/my.cnf
      - ./mysql_data:/var/lib/mysql
    restart: always

  phpmyadmin:
    container_name: phpmyadmin_server  # 指定 phpMyAdmin 容器名稱
    image: phpmyadmin
    restart: always
    ports:
      - 8080:80
    environment:
      - PMA_ARBITRARY=1