Evolve Web Hosting Help
Evolve Web Hosting Homepage Evolve Web Hosting Portal Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

Published on: 02/09/2023 | Updated on: 01/20/2025 | Reading Time: 6 minutes

DirectAdmin Databases

Create a Database

To create a database, start by logging in to your DirectAdmin control panel

Search
The DirectAdmin Search function works very well and makes it very easy to locate the FTP Management page. Type Database in the search bar and the link to the Database page will appear.

If you don’t use the Search Bar for any reason, locate the Account Manager section shown below and click on Databases

DirectAdmin Account Manager Section
DirectAdmin Account Manager Section
MultipleDomains
If you have multiple domains hosted on a single DirectAdmin account, click on the domain name where you see Domain: yourdomain.com (your domain is a blue hyperlink located near the search field) to toggle between the domains to then manage your email accounts.

Scroll down to the section titled Create Database where you will see the screen below

DirectAdmin Create Database Screen
DirectAdmin Create Database Screen

Enter a database name and then click on the blue button CREATE

This is the non advanced mode where DirectAdmin will automatically generate a database username for you along with a password

Create Database Using Advanced Mode

If you would like to create your own name for the database user, click the box to toggle the Advanced options. You will see a screen similar to the one shown Below

DirectAdmin Create Database Advanced Mode Screen
DirectAdmin Create Database Advanced Mode Screen

If you need any assistance, please submit a ticket for Technical Support


Delete a Database

Before you begin, you may wish to generate a backup file of your database

Difficulty Level: Easy to Medium

  1. Login to your DirectAdmin Account
Search
The DirectAdmin Search function works very well and makes it very easy to locate the FTP Management page. Type Databases in the search bar and the link to the Databases page will appear.
  1. If you don’t want to use the Search Bar for any reason, use the menu once you are logged in, navigate to Account Manager > Databases
DirectAdmin Account Manager Section
DirectAdmin Account Manager Section
  1. Click on Databases
MultipleDomains
If you have multiple domains hosted on a single DirectAdmin account, click on the domain name where you see Domain: yourdomain.com (your domain is a blue hyperlink located near the search field) to toggle between the domains to then manage your email accounts.
  1. Locate the database you wish to Delete from the Database List
DirectAdmin List of Databases Screen
DirectAdmin List of Databases Screen
  1. Click the button that says Delete

Database users

Create a new Database User

DirectAdmin Database Users Screen
DirectAdmin Database Users Screen
Search
The DirectAdmin Search function works very well and makes it very easy to locate the FTP Management page. Type Databases in the search bar and the link to the Databases page will appear.

Difficulty Level: Easy

In order to connect to and use a database for your website application, you need to create a User and assign it to the database you’re working with.

In order to Create a New Database User follow these Steps

  1. Login to your DirectAdmin Control Panel
  2. Either use the Search bar and type in Database User or locate the icon for Databases found in the Account Manager Section
  3. Click the icon to load that page
    MultipleDomains
    If you have multiple domains hosted on a single DirectAdmin account, click on the domain name where you see Domain: yourdomain.com (your domain is a blue hyperlink located near the search field) to toggle between the domains to then manage your email accounts.
  4. You will see a list of your existing databases. In the upper right corner of this section, locate the text that says Manage Users and click it.
  5. The next page will show any existing Database Users with an option right below to create a new User and password. Fill in the fields and click Create.
  6. After clicking Create Directadmin will show you the new Username and Passowrd that you created along with a button to copy the password. This way you can easily update any website config file(s) used to connect to your database.

Add a Database User to an Existing Database

  1. Make sure you are logged into your DirectAdmin Control Panel
  2. Either search the term Databases or Navigate to Account Manager > Databases and click the link
    MultipleDomains
    If you have multiple domains hosted on a single DirectAdmin account, click on the domain name where you see Domain: yourdomain.com (your domain is a blue hyperlink located near the search field) to toggle between the domains to then manage your email accounts.
  3. On the Database page, locate the text Manage Users near the upper right area of your screen and click on it
  4. Locate the Database User from the list of User Accounts and click Manage
  5. On the next screen, scroll down to the section Access to Databases If the User is assigned to any database(s) already, you will see them listed as shown in the illustration below
DirectAdmin Access to Databases Screen
DirectAdmin Access to Databases Screen

If the User is not assigned to any databases, you’ll see the screen shown below

DirectAdmin Access to Databases Screen
DirectAdmin Access to Databases Screen
  1. From the dropdown located below the text Grant Access to Additional Database choose the database to assign this User to and click Grant full access - you can modify the access permissions after if needed

Update the Password for an Existing Database User

Difficulty Level: Easy

  1. Start by logging into your DirectAdmin Control Panel
  2. Either type databases into the search bar and select the link or navigate using the menu to Account Manager > Database Management and click the link to load the Databases page
    MultipleDomains
    If you have multiple domains hosted on a single DirectAdmin account, click on the domain name where you see Domain: yourdomain.com (your domain is a blue hyperlink located near the search field) to toggle between the domains to then manage your email accounts.
  3. Near the top right corner of the page, click Manage Users
  4. After clicking Manage Users you’ll see a screen that looks like the one shown below
DirectAdmin Database Users Screen
DirectAdmin Database Users Screen
  1. From the list of Database Users, locate the User you wish to update the password for and click Manage next to that Username. You will then see a screen similar to the one shown below
DirectAdmin Change User Password for a Database User Screen
DirectAdmin Change User Password for a Database User Screen
  1. Either use the automatic password generator by clicking the icon to the left of the password field or enter your own strong and unique password and click Create

Remember to update the password in any website config file(s) so that your website continues to connect to the database and work properly


Database Operations

From your DirectAdmin Control Panel, perform the following functions:

  1. Create a backup of your sql file
  2. Import a new sql file into an empty database
  3. Check your database for errors
  4. Repair your database if errors exist
  5. Optimize your database for better performance
DirectAdmin Database Operations Screen
DirectAdmin Database Operations Screen

Difficulty Level: Easy to Moderate

  1. Start by logging into your DirectAdmin Control Panel
  2. Either type databases into the search bar and select the link or navigate using the menu to Account Manager > Database Management and click the link to load the Databases page
    MultipleDomains
    If you have multiple domains hosted on a single DirectAdmin account, click on the domain name where you see Domain: yourdomain.com (your domain is a blue hyperlink located near the search field) to toggle between the domains to then manage your email accounts.
  3. From the Database List (screenshot shown below), locate the Database that you wish to perform one of the noted functions on and click Manage next to that database name
DirectAdmin List of Databases Screen
DirectAdmin List of Databases Screen
  1. You will now see the screen shown below
DirectAdmin Database Operations Screen
DirectAdmin Database Operations Screen
  1. Choose any one of the listed functions depending on your needs

If you need any assistance, please submit a ticket for Technical Support


DirectAdmin Databases Official Documentation