services:
  mysql:
    image: mysql:8.4
    container_name: royal-mysql
    restart: unless-stopped
    environment:
      MYSQL_DATABASE: royal_portal
      MYSQL_USER: royal_user
      MYSQL_PASSWORD: royal_password
      MYSQL_ROOT_PASSWORD: root_password
    ports:
      - "3306:3306"
    volumes:
      - royal_mysql_data:/var/lib/mysql

volumes:
  royal_mysql_data: