cPanel Database & System Assistant

Titan POS • PHP 8.2.33 • PDO MySQL

Invoices Unban Center Login Screen Terminal

Connection Health

Connected to MySQL

Database: solowebn_pos_db
Host: 127.0.0.1
User: solowebn_pos_user

PDO Driver: Enabled (OK)
Admin Account: Ready (@admin)
Total Products: 12 items
Credit Directory: 4 customers

Configure cPanel MySQL Credentials

Enter your cPanel database details below. Clicking "Test & Save" immediately validates the connection and saves it directly to config/db_config.php.

Usually localhost or 127.0.0.1 on cPanel.

Find this in cPanel → MySQL Databases (it always includes your cPanel prefix).

Target: config/db_config.php

Database Schema & Features Verification

Ensures all newly added features have their tables
pos_users READY (4)

System Staff & Roles

pos_inventory READY (12)

Inventory & Stock Catalog

pos_customers READY (4)

Customer Credit Directory & NIN

pos_customer_credits READY (0)

Credit Invoices & Aging

pos_sales READY (5)

Transactions & Receipts

pos_sale_items READY (11)

Sale Line Items

pos_shifts READY (1)

Cash Register Shifts

pos_expenses READY (1)

Store Expenditures Ledger

pos_refunds READY (2)

Managerial Refunds & Returns

pos_audit_logs READY (20)

Security & Action Audit Logs

pos_login_attempts READY (6)

Security & Rate Limiting

pos_banned_ips READY (0)

Firewall & Banned Terminal IPs

How to Deploy on cPanel in 4 Steps:

1. Upload Files

Upload the contents of the php/ folder directly into your cPanel public_html.

2. Create MySQL DB

In cPanel, go to MySQL Databases, create a database and user, and assign ALL PRIVILEGES.

3. Import schema.sql

Open phpMyAdmin, select your database, click Import, and upload schema.sql.

4. Run db_check.php

Open yourdomain.com/db_check.php, save your DB credentials, and log in with admin / admin123.