How can I create and manage MySQL databases?

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 that user's password
4. Use phpMyAdmin to run queries, import/export, and manage tables

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

Access from outside: Access Hosts

By default, only your website itself can reach your database. Want to connect from another computer or server? Then add that IP address as an access host:

1. Go to MySQL Management and click your database
2. Under Access Hosts, add the IP address that needs to connect
3. Save

Only add fixed IP addresses that you know. See Can my website connect to an external database or server?

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