> For AI agents: the complete documentation index is available at /llms.txt, the full documentation bundle is available at /llms-full.txt.

# How to Create and Manage a Database in DirectAdmin

Databases in DirectAdmin are commonly used by WordPress, Joomla, other CMS platforms, and custom applications.

Creating and managing databases in DirectAdmin is straightforward. This guide explains how to create a database, change a database user's password, upload an existing database backup, and delete a database.

You will need **User Level** access to your DirectAdmin account.

:::info

If you are using the Standard Theme in DirectAdmin, switch to the Refreshed Theme by following [How to Change Theme or Layout on DirectAdmin](/directadmin/directadmin_ui_customization/how_to_change_theme_or_layout_on_directadmin.md)

:::

## In the Standard Theme


Click here to show the steps

## Create Database

### Log in to DirectAdmin
Log in to the DirectAdmin control panel as a user.
Navigate to **Account Manager** → **MySQL Management**.
<img alt="MySQL Management option in DirectAdmin Standard Theme" src={image0} />
### Open Create New Database
On the right sidebar, click **Create New Database** to start creating a database.
<img alt="Create New Database option in DirectAdmin Standard Theme" src={image1} />
### Enter database details
Enter the database name, username, and password.
The following details are required:
1. **Database Name:** The name assigned to the database. You will need this when configuring your application to connect to MySQL. For example, `site_name` or `wordpress_db`.
2. **Database User and Password:** These credentials are used to authenticate access to the database. For example, `site_name_user` or `wordpress_db_user`.
Click **Create Database** to create the database.
### View database details
DirectAdmin will display the details of the newly created database account.
<img alt="Newly created database account details" src={image2} />

## Change Database User Password

### Open MySQL Management
Log in to DirectAdmin as a **User** and navigate to **Account Manager** → **MySQL Management**.
### Select the database
Select the database for which you want to change the password.
DirectAdmin will display a list of usernames associated with the database.
### Open the password change option
Click **Change Password** next to the database user whose password you want to change.
<img alt="Change Database User Password option" src={image3} />
### Set the new password
Enter the new password in the dialog box and click **Save**.
<img alt="Change Database User Password dialog" src={image4} />

## Upload Database Backup

### Open MySQL Management
Log in to DirectAdmin as a **User** and navigate to **Account Manager** → **MySQL Management**.
### Create the database
Before uploading a database backup, you must first create the destination database.
Refer to the [Create Database](#create-database) section of this guide for instructions.
### Open Upload Backup
Once the database is created, click **Upload Backup** on the right sidebar.
<img alt="Upload Backup option in DirectAdmin Standard Theme" src={image5} />
### Upload the backup file
Select the database name from the dropdown menu and drag and drop the backup file into the upload area.
:::note
The database backup file must be in `.sql` format.
:::
<img alt="Upload database backup in DirectAdmin Standard Theme" src={image6} />

## Delete Database

### Open MySQL Management
Log in to DirectAdmin as a **User** and navigate to **Account Manager** → **MySQL Management**.
### Select the database
Select the checkbox beside the database name you want to delete.
<img alt="Select database for deletion" src={image7} />
### Delete the database
From the available options, click **Delete**.
### Confirm deletion
A confirmation dialog will appear. Click **Delete** again to confirm the action.
<img alt="Confirm database deletion" src={image8} />

## In the Refreshed Theme

## Create Database


### Log in to DirectAdmin
Log in to the DirectAdmin control panel as a user.
Navigate to **Account Manager** → **MySQL Management**.
<img alt="MySQL Management option in DirectAdmin Refreshed Theme" src={image9} />
### Open Create New Database
On the right sidebar, click **Create New Database** to start creating a database.
<img alt="Create New Database option in DirectAdmin Refreshed Theme" src={image10} />
### Enter database details
Enter the database name, username, and password.
The following details are required:
1. **Database Name:** The name assigned to the database. You will need this when configuring your application to connect to MySQL. For example, `site_name` or `wordpress_db`.
2. **Database User and Password:** These credentials are used to authenticate access to the database. For example, `site_name_user` or `wordpress_db_user`.
Click **Create Database** to create the database.
### View database details
DirectAdmin will display the details of the newly created database account.
<img alt="Newly created database account details" src={image11} />

## Change Database User Password


### Open MySQL Management
Log in to DirectAdmin as a **User** and navigate to **Account Manager** → **MySQL Management**.
### Select the database
Select the database for which you want to change the password.
DirectAdmin will display a list of usernames associated with the database.
### Open the password change option
Click **Change Password** next to the database user whose password you want to change.
<img alt="Change Database User Password option" src={image12} />
### Set the new password
Enter the new password in the dialog box and click **Save**.
<img alt="Change Database User Password dialog" src={image13} />

## Upload Database Backup


### Open MySQL Management
Log in to DirectAdmin as a **User** and navigate to **Account Manager** → **MySQL Management**.
### Create the database
Before uploading a database backup, you must first create the destination database.
Refer to the [Create Database](#create-database) section of this guide for instructions.
### Open Upload Backup
Once the database is created, click **Upload Backup** on the right sidebar.
<img alt="Upload Backup option in DirectAdmin Refreshed Theme" src={image14} />
### Upload the backup file
Select the database name from the dropdown menu and drag and drop the backup file into the upload area.
:::note
The database backup file must be in `.sql` format.
:::
<img alt="Upload database backup in DirectAdmin Refreshed Theme" src={image15} />

## Delete Database


### Open MySQL Management
Log in to DirectAdmin as a **User** and navigate to **Account Manager** → **MySQL Management**.
### Select the database
Select the checkbox beside the database name you want to delete.
<img alt="Select database for deletion" src={image16} />
### Delete the database
From the available options, click **Delete**.
### Confirm deletion
A confirmation dialog will appear. Click **Delete** again to confirm the action.
<img alt="Confirm database deletion" src={image17} />

:::warning

Deleting a database permanently removes its data. Make sure you have a backup before proceeding.

:::

This concludes the guide to creating and managing databases in DirectAdmin.

If you have any questions or issues, please open a [Support Ticket](https://crowncloud.net/clients/submitticket.php), and our team will assist you.
