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
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
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
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.
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
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.
Locate the database you wish to Delete from the Database List
DirectAdmin List of Databases Screen
Click the button that says Delete
Database users
Create a new Database User
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
Login to your DirectAdmin Control Panel
Either use the Search bar and type in Database User or locate the icon for Databases found in the Account Manager Section
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.
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.
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.
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
Make sure you are logged into your DirectAdmin Control Panel
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.
On the Database page, locate the text Manage Users near the upper right area of your screen and click on it
Locate the Database User from the list of User Accounts and click Manage
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
If the User is not assigned to any databases, you’ll see the screen shown below
DirectAdmin Access to Databases Screen
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
Start by logging into your DirectAdmin Control Panel
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.
Near the top right corner of the page, click Manage Users
After clicking Manage Users you’ll see a screen that looks like the one shown below
DirectAdmin Database Users Screen
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
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:
Create a backup of your sql file
Import a new sql file into an empty database
Check your database for errors
Repair your database if errors exist
Optimize your database for better performance
DirectAdmin Database Operations Screen
Difficulty Level: Easy to Moderate
Start by logging into your DirectAdmin Control Panel
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.
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
You will now see the screen shown below
DirectAdmin Database Operations Screen
Choose any one of the listed functions depending on your needs