How do I create a database in DirectAdmin?

How do I create a database in DirectAdmin?

Overview

You may need to create a MySQL database when installing applications like WordPress or other web software. DirectAdmin allows you to create databases, users, and assign permissions in a few simple steps.

Step-by-Step Guide

Log in to your DirectAdmin control panel

Go to Account Manager

Click MySQL Management

Click Create New Database

Enter a database name (this will be prefixed automatically by your hosting account username)

Create a database username and password

Confirm the password

Click Create

Assigning Database Access

After creating the database:

Ensure the user is assigned to the database

Set privileges to ALL PRIVILEGES (recommended for WordPress and most apps)

Save changes

Important Notes

Keep your database name, username, and password safe Each website should ideally have its own database Weak passwords can compromise your website security You will need these details when installing WordPress or other applications

Common Issues & Fixes

Cannot create database You may have reached your hosting database limit

Wrong login details error Double-check database name, username, and password in your configuration file

User not assigned to database Ensure the user has been properly linked with full privileges

Need Help?

If you are unsure how to create or connect a database, our support team can set it up for you and ensure it is correctly configured for your website.