# Database connection (local reference — DO NOT COMMIT)

This file is gitignored. App credentials live in `.env`.

| Setting | Value |
|---|---|
| Type | MySQL / MariaDB |
| Remote host (from Mac / external) | `95.217.197.232` |
| Server (on hosting / phpMyAdmin) | Localhost via UNIX socket |
| Version | MariaDB 10.11.18 |
| Database | `tzyytzhn_KarobariSuite` |
| User | `tzyytzhn_admin` |
| Password | Manish@16 |
| Charset (app) | utf8mb4 |
| Server default charset | latin1 (override per session / prefer ALTER DATABASE later) |
| Server IP | 95.217.197.232 |
| phpMyAdmin / cPanel user | tzyytzhn |

## Important

- **Do not use SQLite.**
- From local Mac / CI: `DB_HOST=95.217.197.232`
- From PHP on the same cPanel server: `DB_HOST=localhost` is fine
- If remote connect is denied, add your IP under cPanel → **Remote MySQL**

User: tzyytzhn_admin  
Database: tzyytzhn_KarobariSuite
Password: Manish@16