Hosting Question? Find the Solution -

KNOWNHOST KNOWLEDGE BASE

Browse our Guides, Articles, and How-To's

How to create a MySQL Database in DirectAdmin?

Category: DirectAdmin
Tags: # # #

For storage of data for applications, you must need a Database. Traditionally we use a command-line interface for creating a database and assigning a user to it. In DirectAdmin, we can perform all the actions using the graphical user interface. Let’s see how to create and manage databases, users in DirectAdmin?


How to create a MySQL Database in DirectAdmin?

1. First, to login into DirectAdmin control panel visit, 

https://your-domain.com:2222 or https://IP-address:2222 or https://server-hostname:2222.

login-into-directadmin

2. Navigate to Account Manager → MySQL Management.

navigate-to-mysql-management

3. To create database → Click on CREATE NEW DATABASE.

4. Here, enter the datbase name → To create a new user for database → De-select (Same as database name) → Enter the Username → Configure the Password.

5. Finally, click on CREATE DATABASE.

6. Congratulations! You have successfully created a database and user in DirectAdmin.

How-to-create-MySQL-Database-and-User-in-DirectAdmin

How to delete a MySQL Database in DirectAdmin?

1. First, to login into DirectAdmin control panel visit, 

https://your-domain.com:2222 or https://IP-address:2222 or https://server-hostname:2222.

login-into-directadmin

2. Navigate to Account Manager → MySQL Management.

navigate-to-mysql-management

3. Select Database → Click on Delete.

4. Again, you will be asked to confirm deletion of selected Database → Click on Delete.

confirm-delete-mysql-database-directadmin

5. Congratulations! You have sucessfully deleted selected MySQL Database.


Conclusion

Now that we’ve gone over how to create a MySQL database in DirectAdmin step-by-step. Also, using this article, you can delete the existing or newly created MySQL database quickly. Use this article and get started with creating and managing MySQL databases.

KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team ready to help you with requests should you need our assistance. You’re not using KnownHost for the best webhosting experience? Well, why not? Check with our Sales team to see what can KnownHost do for you in improving your webhosting experience.