# XAMPP Setup Guide

## Step 1: XAMPP MySQL Start Karein

1. XAMPP Control Panel kholein
2. **MySQL** service start karein (port 3306)
3. **Apache** bhi start karein (phpMyAdmin ke liye)

## Step 2: Database Create Karein

**Option A: phpMyAdmin se (Easy)**
1. Browser mein jayein: `http://localhost/phpmyadmin`
2. Click **"New"** (left sidebar)
3. Database name: `wild_dubai`
4. Click **"Create"**

**Option B: Command Line se**
```bash
cd /Applications/XAMPP/xamppfiles/bin
./mysql -u root -p
# Password empty hai to directly Enter press karein

CREATE DATABASE wild_dubai CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
EXIT;
```

## Step 3: Tables Import Karein

**phpMyAdmin se:**
1. `wild_dubai` database select karein
2. **"Import"** tab pe click karein
3. `packages/database/schema.sql` file select karein
4. **"Go"** button click karein

**Command Line se:**
```bash
cd /Applications/XAMPP/xamppfiles/bin
./mysql -u root wild_dubai < "/Users/muzamilirfan/Desktop/Wild Dubai/packages/database/schema.sql"
```

## Step 4: .env File Configure Karein

```bash
cd "/Users/muzamilirfan/Desktop/Wild Dubai"
cp .env.xampp .env
```

Ya manually `.env` file banayein:

```env
DB_HOST=localhost
DB_PORT=3306
DB_USER=root
DB_PASSWORD=
DB_NAME=wild_dubai
DATABASE_URL=mysql://root:@localhost:3306/wild_dubai

JWT_SECRET=your-secret-key-here-min-32-chars
JWT_REFRESH_SECRET=your-refresh-secret-here

NEXT_PUBLIC_API_URL=http://localhost:3001
PORT=3001
```

## Step 5: Backend Start Karein

```bash
cd "/Users/muzamilirfan/Desktop/Wild Dubai/apps/api"
npm run dev
```

Terminal pe yeh message aana chahiye:
```
✅ Database connected successfully
🚀 API Server running on port 3001
```

## Step 6: Frontend Start Karein (New Terminal)

```bash
cd "/Users/muzamilirfan/Desktop/Wild Dubai/apps/web"
npm run dev
```

Browser mein jayein: `http://localhost:3000`

## Common Issues

### Issue 1: "Access denied for user 'root'@'localhost'"
**Solution:** XAMPP mein root password set karein ya `.env` mein password add karein

### Issue 2: "ECONNREFUSED ::1:3306"
**Solution:** MySQL service running check karein XAMPP control panel mein

### Issue 3: "Unknown database 'wild_dubai'"
**Solution:** Database create karna bhool gaye - Step 2 follow karein

## Default XAMPP MySQL Credentials
- **Host:** localhost
- **Port:** 3306
- **User:** root
- **Password:** (empty - kuch nahi)

## MySQL Service Stop/Start
```bash
# Stop
sudo /Applications/XAMPP/xamppfiles/bin/mysqladmin -u root shutdown

# Start via XAMPP Control Panel
```

## Testing Connection
```bash
cd /Applications/XAMPP/xamppfiles/bin
./mysql -u root -p -e "SHOW DATABASES;"
```