How can I create and manage MySQL databases?

How to create MySQL databases, manage users, and use phpMyAdmin in DirectAdmin.

DirectAdmin lets you create and manage MySQL databases for applications like WordPress, Joomla, or custom scripts.

Creating a database

1. 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
2. Go to MySQL Management → Create new database
3. Enter a database name and click Create
4. Create a database user, set a password, and assign it to the database
5. 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

1. Go to MySQL Management
2. Click phpMyAdmin to open it in a new tab
3. Log in with your database user and password
4. Use phpMyAdmin to run queries, import/export, and manage tables

INFO

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

• DirectAdmin MySQL Documentation