Guide Web hosting

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

  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

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?

Did not find what you were looking for?

Open a ticket and our team will look into it with you. For a quick question, Discord works too.

Open a ticket Go to Discord