╔═══════════════════════════════════════════════════════════════════════════════╗
║                  YOUR ACTUAL DATABASE CREDENTIALS                             ║
╚═══════════════════════════════════════════════════════════════════════════════╝

📊 DATABASE INFORMATION
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Database Name:     mindoxah_khelopak_db
Database Username: mindoxah_khelopak
Database Password: [YOU NEED TO SET THIS]
Database Host:     localhost
Database Port:     3306


✅ WHAT YOU NEED TO DO:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

STEP 1: Import Database
────────────────────────────────────────────────────────────────────────────
1. Login to cPanel
2. Go to phpMyAdmin
3. Click on database: mindoxah_khelopak_db (in left sidebar)
4. Click "Import" tab
5. Choose File: shop.sql
6. Click "Go"
7. Wait for success message


STEP 2: Update .env File After Upload
────────────────────────────────────────────────────────────────────────────
After uploading your project to cPanel, edit the .env file and set:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=mindoxah_khelopak_db
DB_USERNAME=mindoxah_khelopak
DB_PASSWORD=YOUR_ACTUAL_PASSWORD_HERE    ← Replace with real password


🔑 WHERE TO FIND/SET DATABASE PASSWORD:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

If you already created the database user and forgot the password:
───────────────────────────────────────────────────────────────────────────
1. cPanel → MySQL® Databases
2. Scroll to "Current Users"
3. Find: mindoxah_khelopak
4. Click "Change Password"
5. Enter new strong password
6. Save and use this password in .env

If you haven't created the user yet:
────────────────────────────────────────────────────────────────────────────
1. cPanel → MySQL® Databases
2. Scroll to "Add User To Database"
3. User: mindoxah_khelopak
4. Database: mindoxah_khelopak_db
5. Privileges: ALL PRIVILEGES ✓
6. Make Changes


📝 COPY-PASTE READY .ENV SETTINGS:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Copy these lines and paste into your .env file on cPanel:
────────────────────────────────────────────────────────────────────────────

APP_NAME="KheloPakistan"
APP_ENV=production
APP_DEBUG=false
APP_URL="https://khelo.mindoxahost.com"
APP_TIMEZONE="Asia/Karachi"

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=mindoxah_khelopak_db
DB_USERNAME=mindoxah_khelopak
DB_PASSWORD=YOUR_PASSWORD_HERE

FORCE_HTTPS="On"


✅ VERIFICATION CHECKLIST:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

□ Database mindoxah_khelopak_db exists in cPanel
□ User mindoxah_khelopak has ALL PRIVILEGES on the database
□ Database password is set and noted down
□ shop.sql imported successfully (118 tables)
□ .env file updated with correct credentials
□ APP_DEBUG=false for production
□ APP_URL set to https://khelo.mindoxahost.com


🚨 IMPORTANT NOTES:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• Database prefix is "mindoxah_" (without the 't')
• ALWAYS use strong passwords for production
• Never share database credentials publicly
• Keep .env file secure (already protected by .htaccess)
• Set APP_DEBUG=false before going live


════════════════════════════════════════════════════════════════════════════════
   Your Database: mindoxah_khelopak_db
   Your Username: mindoxah_khelopak
   Your Subdomain: khelo.mindoxahost.com
════════════════════════════════════════════════════════════════════════════════