aaPanel
MySQL
Beginner
Database management in aaPanel-create users and databases
Create MySQL databases and users in aaPanel, set permissions, access phpMyAdmin, and manage from the aaPanel interface.
UnderHost NOC
Network Operations
On this page
aaPanel provides an integrated database manager for MySQL/MariaDB operations. You can create databases, users, and access phpMyAdmin without command-line.
Access database manager
- Log in to aaPanel
- Click Database icon in left sidebar
- Select MySQL from tab options
Create new database
- In Database manager, click "Add Database"
- Enter database name (alphanumeric, no spaces)
- Select Character Set (utf8mb4 recommended)
- Click Confirm
Create database user
- In Database manager, click "Add User"
- Enter username (alphanumeric)
- Set password (use strong password)
- Assign user to database(s)
- Set privileges (All Privileges for WordPress)
- Click Confirm
Access phpMyAdmin
- In Database manager, click phpMyAdmin icon next to database
- Log in with database user credentials
- Import/export, run queries, manage tables
Backup database in aaPanel
- Click database name, then "Backup" tab
- Set backup frequency (daily/weekly/monthly)
- Backups stored in /www/backup/database/
Use aaPanel instead of command line
aaPanel GUI is faster and less error-prone than SSH commands for basic database tasks. Use command-line only for advanced operations.
Related: aaPanel overview | Database admin
Was this article helpful?
Need aaPanel hosting?
Install aaPanel on an UnderHost VPS or dedicated server when you want a simple web interface for sites, databases, SSL, and apps.
