Managing Databases in DirectAdmin
Summary
This guide explains how to create, manage, and delete MySQL databases and users in DirectAdmin. Databases are required for most dynamic websites, including WordPress, Joomla, and many PHP applications.
Overview
The Databases section allows you to create new databases, assign users, reset passwords, and remove databases you no longer need. DirectAdmin uses MySQL or MariaDB as the database engine, and phpMyAdmin is available for advanced management.
Requirements
- DirectAdmin user-level access
- A domain or hosting account with database support
- Database name, username, and password for application setup
Step-by-Step Instructions
1. Access the Databases Section
- Log in to DirectAdmin
- Go to Account Manager → MySQL Management
2. Create a New Database
- Click “Create New Database”
- Enter:
• Database name
• Database username
• Password (or generate one)
- Click “Create”
Note: DirectAdmin may automatically prefix database names and usernames.
3. View Database Details
- Go to MySQL Management
- Find your database in the list
- Click the database name to view:
• Users assigned
• Permissions
• Connection details
4. Change a Database User Password
- In MySQL Management, find the user
- Click “Change Password”
- Enter a new password
- Save changes
5. Delete a Database
- Go to MySQL Management
- Find the database you want to remove
- Click “Delete”
- Confirm deletion
Warning: This permanently removes all tables and data.
6. Access phpMyAdmin
- In MySQL Management, click “phpMyAdmin”
- Log in using:
• Database username
• Database password
- Use phpMyAdmin to:
• Import/export databases
• Run SQL queries
• Edit tables and rows
Troubleshooting
Cannot Connect to Database
- Verify the correct username and password
- Ensure the application config file matches your database details
- Check for extra spaces or hidden characters in credentials
Database Connection Errors in Applications
- Confirm the database host (usually “localhost”)
- Ensure the database user has permissions for that database
- Reset the database user password if unsure
Import/Export Issues in phpMyAdmin
- Large files may exceed upload limits
- Use compressed .sql.gz files when possible
- For very large imports, use SSH or contact support
Database Not Showing Up
- Refresh the MySQL Management page
- Ensure the database was created under the correct user account
Related Articles
- File Manager
- Domains
- phpMyAdmin
- System Information