How to Create and Manage Database in DirectAdmin

DataBases in DirectAdmin are typically used by Wordpress, Joomla, or any other CMS or your custom Application.

Creating and managing the database in DirectAdmin is easy, in this article, we show you how to create database, reset password, upload existing database backups and deleting the database.

For this, you will need User level access to DirectAdmin account.

If you are using Standard Theme on your DirectAdmin please click the following dropdown, change to Refreshed theme as shown here

In Standard Theme

Click here

Create Database

1. Log into DirectAdmin control panel as a User, Then navigate to Account Manager -> MySQL Management. 2. On the Right sidebar, click on Create New Database to start creating a new Database. 3. Database Name is the name given to the database, this is required when configuring your application to connect to MySQL. For example: site_name, wordpress_db etc 4. Database User and Password is used to authenticate and access to the database. For example: site_name_user, wordpress_db_user etc 5. Click on Create Database and done! Your database has been created now. You will be presented with the details of the Database account,

Change Database User Password

1. Log into DirectAdmin as User, Then navigate to Account Manager -> MySQL Management. 2. Select the Database you want to reset the password for. 3. This will show you a list of usernames associated with the database. 4. Click on Change Password for the user you want to change password. 5. You will be presented with a dialog box to enter the new password. Once you've entered the new password, click on Save button.

Upload Database Backup

1. Log into DirectAdmin as User, Then navigate to Account Manager -> MySQL Management. 2. In order to upload your Database backup to DirectAdmin, you will first need to create the Database. For this, you can refer the Create Database section of this wiki. 3. Once you've created the required Database, click on the Upload Backup link on the right side bar. 4. You will be presented with a small window box to select the Database name from the dropdown and to drag and drop the backup file.

Delete Database

1. Log into DirectAdmin as User, Then navigate to Account Manager -> MySQL Management. 2. Select the Database by "ticking" the checkbox beside the Database name. 3. You will be presented with a series of options, among them, click on Delete button to delete the Database. 4. A window box will pop up to confirm the action once again, confirm the action by clicking on Delete.


In Refreshed Theme

Create Database

  1. Log into DirectAdmin control panel as a User, Then navigate to Account Manager -> MySQL Management.

    image

  2. On the Right sidebar, click on Create New Database to start creating a new Database.

    image

  3. Database Name is the name given to the database, this is required when configuring your application to connect to MySQL. For example: site_name, wordpress_db etc

  4. Database User and Password is used to authenticate and access to the database. For example: site_name_user, wordpress_db_user etc

  5. Click on Create Database and done! Your database has been created now. You will be presented with the details of the Database account,

    image

Change Database User Password

  1. Log into DirectAdmin as User, Then navigate to Account Manager -> MySQL Management.

  2. Select the Database you want to reset the password for.

  3. This will show you a list of usernames associated with the database.

  4. Click on Change Password for the user you want to change password.

    DirectAdmin

  5. You will be presented with a dialog box to enter the new password. Once you've entered the new password, click on Save button.

    DirectAdmin

Upload Database Backup

  1. Log into DirectAdmin as User, Then navigate to Account Manager -> MySQL Management.

  2. In order to upload your Database backup to DirectAdmin, you will first need to create the Database.

    For this, you can refer the Create Database section of this wiki.

  3. Once you've created the required Database, click on the Upload Backup link on the right side bar.

    image

  4. You will be presented with a small window box to select the Database name from the dropdown and to drag and drop the backup file.

    Note that the backup file should be a .sql file.

    image

Delete Database

  1. Log into DirectAdmin as User, Then navigate to Account Manager -> MySQL Management.

  2. Select the Database by "ticking" the checkbox beside the Database name.

    image

  3. You will be presented with a series of options, among them, click on Delete button to delete the Database.

  4. A window box will pop up to confirm the action once again, confirm the action by clicking on Delete.

    image

This concludes the topic of Creating and Managing a Database in DirectAdmin.

If you have any questions or issues related to this, please open a Support ticket and our team will assist you with this.