For AI agents: the complete documentation index is available at /llms.txt, the full documentation bundle is available at /llms-full.txt, and this page is available as Markdown at /directadmin/database_management/how_to_create_and_manage_database_in_directadmin.md.

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

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.

MySQL Management option in DirectAdmin Standard Theme

Open Create New Database

On the right sidebar, click Create New Database to start creating a database.

Create New Database option in DirectAdmin Standard Theme

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.

Newly created database account details

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.

Change Database User Password option

Set the new password

Enter the new password in the dialog box and click Save.

Change Database User Password dialog

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 section of this guide for instructions.

Open Upload Backup

Once the database is created, click Upload Backup on the right sidebar.

Upload Backup option in DirectAdmin Standard Theme

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.

Upload database backup in DirectAdmin Standard Theme

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.

Select database for deletion

Delete the database

From the available options, click Delete.

Confirm deletion

A confirmation dialog will appear. Click Delete again to confirm the action.

Confirm database deletion

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.

MySQL Management option in DirectAdmin Refreshed Theme

Open Create New Database

On the right sidebar, click Create New Database to start creating a database.

Create New Database option in DirectAdmin Refreshed Theme

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.

Newly created database account details

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.

Change Database User Password option

Set the new password

Enter the new password in the dialog box and click Save.

Change Database User Password dialog

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 section of this guide for instructions.

Open Upload Backup

Once the database is created, click Upload Backup on the right sidebar.

Upload Backup option in DirectAdmin Refreshed Theme

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.

Upload database backup in DirectAdmin Refreshed Theme

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.

Select database for deletion

Delete the database

From the available options, click Delete.

Confirm deletion

A confirmation dialog will appear. Click Delete again to confirm the action.

Confirm database deletion

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, and our team will assist you.