Database management in DirectAdmin-MySQL and MariaDB

DirectAdmin includes MySQL/MariaDB management tools in the control panel. You can create databases, users, and manage permissions without SSH.

Access database manager

1. Log in to DirectAdmin
2. Click MySQL Management in left sidebar
3. Or: Account Manager → MySQL Management

Create database and user

Create database

1. Click "Create New Database"
2. Enter database name (no spaces)
3. Click Create

Create user and assign to database

1. Click "Create New MySQL User"
2. Enter username and password
3. Select databases to assign
4. Set permissions (ALL for WordPress)
5. Click Create

Use phpMyAdmin

DirectAdmin includes phpMyAdmin for visual database management:

1. Click database name, then phpMyAdmin icon
2. Log in with MySQL user credentials
3. Import/export, run SQL, manage tables

Backup databases

1. Click "Backup" in MySQL Management
2. Select which databases to backup
3. Backups stored in /admin/backup/mysql/

Manage permissions

1. Click database → "Modify Permissions"
2. Check/uncheck privileges (SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP)
3. Click Modify

Related: DirectAdmin overview | User management

Related articles