Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
data	[ DIR ]	drwxr-xr-x	2025-09-15 23:22
uploads	[ DIR ]	drwxr-xr-x	2025-09-15 18:00
COMPLETE_SETUP_GUIDE.md	5.02 KB	-rw-r--r--	2025-09-15 23:45
DATABASE_SETUP.md	2.84 KB	-rw-r--r--	2025-09-15 23:41
FIX_ACCESS_DENIED.md	2.36 KB	-rw-r--r--	2025-09-16 00:07
MIGRATION_SUMMARY.md	4.28 KB	-rw-r--r--	2025-09-15 23:45
NEXT_STEPS.md	2.18 KB	-rw-r--r--	2025-09-15 23:45
PHPMYADMIN_SETUP_GUIDE.md	3.61 KB	-rw-r--r--	2025-09-15 23:43
QUICK_FIX_INSTRUCTIONS.md	1.99 KB	-rw-r--r--	2025-09-16 00:09
admin-dashboard.html	25.26 KB	-rw-r--r--	2025-09-15 17:29
admin-login.html	5.25 KB	-rw-r--r--	2025-09-15 02:24
admin-profile.html	24.21 KB	-rw-r--r--	2025-09-15 17:43
analytics.html	25.08 KB	-rw-r--r--	2025-09-15 16:13
check_mysql.php	1.33 KB	-rw-r--r--	2025-09-15 23:44
cleanup_duplicates.php	1.46 KB	-rw-r--r--	2025-09-15 23:08
complete_workflow_test.php	4.46 KB	-rw-r--r--	2025-09-15 23:22
create_test_user.php	1.15 KB	-rw-r--r--	2025-09-15 23:20
database.php	4.29 KB	-rw-r--r--	2025-09-15 23:43
database_mysql.php	9.98 KB	-rw-r--r--	2025-09-16 00:08
db_config.php	587 B	-rw-r--r--	2025-09-16 00:07
demo-enhanced.html	45.46 KB	-rw-r--r--	2025-09-15 01:43
deposit.html	10.83 KB	-rw-r--r--	2025-09-15 17:08
error_log	825 B	-rw-r--r--	2025-10-04 15:48
fastearnads.sql	6.12 KB	-rw-r--r--	2025-09-15 23:39
fastearnads_tables_only.sql	5.96 KB	-rw-r--r--	2025-09-16 00:07
final_test.php	4.73 KB	-rw-r--r--	2025-09-15 23:29
import_database.bat	1.03 KB	-rw-r--r--	2025-09-15 23:45
index.php	50.11 KB	-rw-r--r--	2025-09-15 23:40
manage-ads.html	25.39 KB	-rw-r--r--	2025-09-15 16:12
manage-users.html	42.4 KB	-rw-r--r--	2025-09-15 16:54
manage-withdraws.html	49.19 KB	-rw-r--r--	2025-09-15 15:54
migrate_data.php	1.6 KB	-rw-r--r--	2025-09-15 23:40
simple-login.html	1.19 KB	-rw-r--r--	2025-09-15 02:08
start_mysql.bat	948 B	-rw-r--r--	2025-09-15 23:45
test_admin_approval.php	3.55 KB	-rw-r--r--	2025-09-15 23:21
test_connection_with_user.php	1.9 KB	-rw-r--r--	2025-09-15 19:19
test_db_connection.php	1.54 KB	-rw-r--r--	2025-09-15 23:41
test_deposit_fix.php	2.88 KB	-rw-r--r--	2025-09-15 23:09
test_frontend.html	3.49 KB	-rw-r--r--	2025-09-15 23:22
test_user_activity_history.php	2.96 KB	-rw-r--r--	2025-09-15 23:21
user-ads.html	18.36 KB	-rw-r--r--	2025-09-15 14:39
user-dashboard.html	47.77 KB	-rw-r--r--	2025-09-15 23:26
user-login.html	5.78 KB	-rw-r--r--	2025-09-15 02:27
user-profile.html	33.93 KB	-rw-r--r--	2025-09-15 18:33
user-register.html	7.56 KB	-rw-r--r--	2025-09-15 02:27
user-transactions.html	31.83 KB	-rw-r--r--	2025-09-15 22:58
user-withdraw.html	29.48 KB	-rw-r--r--	2025-09-15 21:52
user-withdrawals.html	29.17 KB	-rw-r--r--	2025-09-15 21:51
waiting-approval.html	5.46 KB	-rw-r--r--	2025-09-15 03:23

Rename

# FastEarnAds MySQL Database Setup Guide for phpMyAdmin

This guide will help you set up the MySQL database for FastEarnAds using phpMyAdmin.

## Prerequisites

1. phpMyAdmin installed and accessible
2. MySQL server running
3. Access to phpMyAdmin interface (usually at http://localhost/phpmyadmin)

## Step-by-Step Setup Instructions

### Step 1: Access phpMyAdmin

1. Open your web browser
2. Navigate to your phpMyAdmin URL (typically `http://localhost/phpmyadmin`)
3. Log in with your MySQL credentials (default is often username: `root`, password: empty)

### Step 2: Create the Database

1. In phpMyAdmin, click on the "Databases" tab at the top
2. In the "Create database" section:
   - Enter `fastearnads` as the database name
   - Select `utf8mb4_unicode_ci` as the collation
3. Click the "Create" button

### Step 3: Import the SQL File

1. Click on the newly created `fastearnads` database in the left sidebar
2. Click on the "Import" tab at the top
3. Under "File to import":
   - Click "Choose File" 
   - Navigate to your FastEarnAds folder
   - Select the `fastearnads.sql` file (located in the `public` folder)
4. Make sure these settings are selected:
   - Format: SQL
   - Character set of the file: utf-8
5. Click the "Go" button at the bottom right

### Step 4: Verify Database Structure

After importing, you should see the following tables in your `fastearnads` database:
- `users`
- `deposits`
- `user_activities`
- `ads`
- `withdraws`
- `withdraw_methods`
- `user_withdraw_permissions`
- `settings`
- `admin_activities`

### Step 5: Update Database Configuration (if needed)

1. Open the `db_config.php` file in your FastEarnAds `public` folder
2. Update the database credentials if they differ from the defaults:
   ```php
   define('DB_HOST', 'localhost');    // Database host
   define('DB_NAME', 'fastearnads');  // Database name
   define('DB_USER', 'root');         // Database username
   define('DB_PASS', '');             // Database password (empty by default)
   ```

### Step 6: Test Database Connection

1. Open a terminal/command prompt
2. Navigate to your FastEarnAds `public` folder
3. Run the test script:
   ```bash
   php test_db_connection.php
   ```
4. You should see a success message if the connection is working

### Step 7: Migrate Existing Data (Optional)

If you have existing data in JSON files that you want to migrate to MySQL:

1. Run the migration script:
   ```bash
   php migrate_data.php
   ```
2. This will transfer all data from your JSON files to the MySQL database

## Troubleshooting

### Common Issues:

1. **Access Denied**: 
   - Make sure your MySQL username and password are correct in `db_config.php`
   - Check that MySQL server is running

2. **Import Errors**:
   - Ensure the SQL file is not corrupted
   - Check that you selected the correct database before importing

3. **Connection Failed**:
   - Verify that the database name in `db_config.php` matches the one you created
   - Check that MySQL is running on the specified host

### Need Help?

If you encounter any issues during setup:
1. Check the error messages carefully
2. Verify all file paths are correct
3. Ensure MySQL service is running
4. Confirm your database credentials are correct

## Verification

After completing the setup:
1. All website functionality should work with the MySQL database
2. User registrations, deposits, and activities should be stored in database tables
3. Admin panel should display data from the database
4. No more JSON file dependencies for data storage

You're now ready to use FastEarnAds with MySQL database!