How can I create and manage MySQL databases?
How to create MySQL databases, manage users, and use phpMyAdmin in DirectAdmin.
By Yvan Watchman Updated
DirectAdmin lets you create and manage MySQL databases for applications like WordPress, Joomla, or custom scripts.
Creating a database
- Log in to DirectAdmin via the link in your welcome email, or go to my.planetnode.net, open your webhosting product, and click the login button
- Go to MySQL Management → Create new database
- Enter a database name and click Create
- Create a database user, set a password, and assign it to the database
- Grant All or specific privileges (SELECT, INSERT, etc.)
Managing users and privileges
- MySQL Management → Manage databases — edit users, passwords, and privileges
- Remove users from databases or delete databases when no longer needed
Using phpMyAdmin
- Go to MySQL Management
- Click phpMyAdmin to open it in a new tab
- Log in with your database user and password
- Use phpMyAdmin to run queries, import/export, and manage tables
Good to know
Use your database username and database password in phpMyAdmin, not your DirectAdmin login.
Connection details for scripts
Use these in your application config (e.g. wp-config.php):
- Host:
localhost - Database: your database name
- User: your database user
- Password: the password you set for the user
Need more database power?
For database-heavy applications or multiple large databases, a managed VPS with a control panel gives you dedicated resources and full control over MySQL configuration.
Additional resources
Did this article help you?
Related articles
Why is SFTP more secure and faster than FTP?
Why SFTP is more secure and often faster than FTP for transferring website files.
When should I consider a managed VPS?
When shared webhosting might not be enough and how a managed VPS with a control panel can help.
How can I monitor my website's resource usage?
How to monitor bandwidth, disk space, and other resource usage for your webhosting.
How do I upload and manage website files?
How to upload and manage website files using the File Manager, permissions, and organization in DirectAdmin.