================================================================================
MindSparx.pro | AlphaCore OS - Database Configuration & Privilege Specification
Production Server: 162.213.248.20 (Webuzo / Apache / LiteSpeed)
Domain: mindsparx.pro
================================================================================

1. DEFAULT CONNECTION PARAMETERS:
--------------------------------------------------------------------------------
DB Host:     localhost  (Fallback: 127.0.0.1)
DB Port:     3306
DB Name:     mindsparx_db
DB User:     mindsparx
DB Password: ##MindSparx##
DB Charset:  utf8mb4
DB Collate:  utf8mb4_unicode_ci

2. MYSQL USER PRIVILEGES & GRANT COMMANDS:
--------------------------------------------------------------------------------
To ensure the database user 'mindsparx' has full DDL and DML permissions so
install.php and runtime queries run without 'Access Denied' or HTTP 500:

Log in to MySQL as root:
    mysql -u root -p

Execute the following SQL commands:
    CREATE DATABASE IF NOT EXISTS mindsparx_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    CREATE USER IF NOT EXISTS 'mindsparx'@'localhost' IDENTIFIED BY '##MindSparx##';
    CREATE USER IF NOT EXISTS 'mindsparx'@'127.0.0.1' IDENTIFIED BY '##MindSparx##';
    GRANT ALL PRIVILEGES ON mindsparx_db.* TO 'mindsparx'@'localhost';
    GRANT ALL PRIVILEGES ON mindsparx_db.* TO 'mindsparx'@'127.0.0.1';
    FLUSH PRIVILEGES;

3. WEBUZO / CPANEL USER PERMISSION STEPS:
--------------------------------------------------------------------------------
If you are managing the database via Webuzo or cPanel UI:
1. Open Webuzo -> "Database" -> "MySQL Databases".
2. Under "Add User to Database":
   - Select User: "mindsparx"
   - Select Database: "mindsparx_db"
   - Click "Add".
3. On the privileges page:
   - Check the box "ALL PRIVILEGES".
   - Specifically verify: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX, CREATE TEMPORARY TABLES, LOCK TABLES.
   - Click "Make Changes".

4. TROUBLESHOOTING CONNECTION ISSUES (PREVENTING HTTP 500):
--------------------------------------------------------------------------------
A. "Connection Refused" or "No such file or directory":
   - In PHP PDO, if host='localhost', PHP attempts to connect via UNIX socket (/var/lib/mysql/mysql.sock).
   - If MySQL socket is located in /tmp/mysql.sock, update DB_HOST in db_config.php to:
     define('DB_HOST', '127.0.0.1');

B. MySQL 8.0 Authentication Plugin:
   - If you see "The server requested authentication method unknown to the client (caching_sha2_password)":
     ALTER USER 'mindsparx'@'localhost' IDENTIFIED WITH mysql_native_password BY '##MindSparx##';
     FLUSH PRIVILEGES;

C. Schema Import via CLI:
   - If you prefer importing schema.sql directly:
     mysql -u mindsparx -p mindsparx_db < schema.sql

================================================================================
Generated for MindSparx AlphaCore OS v2.5.0
================================================================================
