version: '3.8'

services:
  mysql:
    image: mysql:8.0
    container_name: vul-backend-mysql
    environment:
      MYSQL_ROOT_PASSWORD: securitycenter
      MYSQL_DATABASE: vuln_management
    ports:
      - "3306:3306"
    volumes:
      - mysql-data:/var/lib/mysql
      - ./mysql-init.sql:/docker-entrypoint-initdb.d/init.sql
    command: --default-authentication-plugin=mysql_native_password
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "root", "-psecuritycenter"]
      interval: 10s
      timeout: 5s
      retries: 5

volumes:
  mysql-data: