#!/bin/bash

# ==============================
# MySQL DB/User 설정값
# 여기만 수정해서 사용하세요
# ==============================
DB_NAME="ns20_local"
DB_USER="ns20_local"
DB_PASS="ns200909!!"

# ==============================
# 입력값 검증
# ==============================
if [ -z "$DB_NAME" ] || [ -z "$DB_USER" ] || [ -z "$DB_PASS" ]; then
  echo "오류: DB_NAME, DB_USER, DB_PASS 값을 모두 입력해야 합니다."
  exit 1
fi

# ==============================
# MySQL DB/User 생성
# ==============================
sudo mysql <<EOF
CREATE DATABASE IF NOT EXISTS \`${DB_NAME}\`;

CREATE USER IF NOT EXISTS '${DB_USER}'@'localhost'
IDENTIFIED BY '${DB_PASS}';

GRANT ALL PRIVILEGES ON \`${DB_NAME}\`.* TO '${DB_USER}'@'localhost';

FLUSH PRIVILEGES;
EOF

echo "================================"
echo "MySQL DB/User 생성 완료"
echo "DB_NAME : $DB_NAME"
echo "DB_USER : $DB_USER"
echo "HOST    : localhost"
echo "================================"