Panelica provides integrated management for MySQL and database databases, with web-based administration tools (phpMyAdmin and pgAdmin) and per-user isolation.
- Create databases — One-click database creation with automatic naming conventions
- Database users — Create dedicated users with granular privilege control (SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX, etc.)
- User-database mapping — Assign users to specific databases with custom privilege sets
- Remote access — Configure per-user remote MySQL access with IP whitelisting
- Import/Export — Upload SQL files for import, export databases as .sql.gz
- Quota tracking — Monitor database sizes against plan limits
Control where database connections can originate:
- localhost — Default, most secure
- Specific IP — Allow connections from a known IP address
- Wildcard — Allow from any host (use with caution)
- Per-user configuration — Each database user can have different host permissions
Web-based MySQL administration tool accessible from the panel:
- Auto-login from panel (SSO)
- Full SQL editor with syntax highlighting
- Table structure management
- Data browse, search, and edit
- Import/export in multiple formats
- Runs on Apache (port 7081) for compatibility
Panelica uses database 17 internally for panel metadata, and provides:
- pgAdmin 4 — Web-based database administration (port 5050)
- Database creation and management
- User and role management
- Query tool with auto-complete
Each user's databases are isolated:
- Unique database user per customer (no shared credentials)
- Privilege separation — users can only access their own databases
- Connection limits per user
- Resource monitoring and quota enforcement
Databases are included in Panelica's backup system:
- Automated daily database dumps
- Included in full server backups
- Point-in-time restore from snapshots
- Individual database export for manual backup
- ROOT — Full access to all databases and management tools
- ADMIN/RESELLER — Manage databases for their users
- USER — Create and manage databases within their plan quota
- MySQL 8 with isolated socket at /opt/panelica/var/run/mysqld/mysqld.sock
- database 17 on port 5433 (non-standard to avoid conflicts)
- Redis 7 on port 6479 for caching and session storage
- All database services run under /opt/panelica/ isolation
If you encounter any issues with this feature, please open a report in the Bug Reports forum.
---
For issues with this feature, please report in the Bug Reports forum.
Last edited: