Creating a Database in DirectAdmin

Step 1: Log in to your DirectAdmin Hosting Account

Open your web browser and navigate to your DirectAdmin login page. The URL should be something like: serverhostname.com:2222 (replace "serverhostname.com" with your actual servers hostname or your own domain name).

Enter your DirectAdmin username and password to log in to the control panel.

Step 2: Access the MySQL Management interface

In the DirectAdmin dashboard, scroll down to the Account Manager section.

  • Click on MySQL Managementto access the database management interface.

Step 3: Create a New Database

In the MySQL Management page, click on Create new Database to create a new database.

  • Enter a unique name for your database and database user in the provided field.
  • Enter a password for the database in the Database Password field.
  • Once complete, click the Create Databasebutton to create the new database.

Creating Additional Database Users (Optional)

After creating the database, navigate back to the MySQL Management interface.

  • Click on the Database you would like to add the new database user too.
  • Click on the Create New Userbutton to create a new user for the database.
  • Enter a username and password for the new database user.
  • Click the Createbutton to create the new database user.

Modifying or Granting Database Permissions (Optional)

To modify user permissions, navigate back to the MySQL Management interface.

  • Click on the Database that you would like to modify the user permissions for.
  • Click on Modify Privilegesnext to the user.
  • Grant/Remove the specific privileges for the user (e.g., SELECT, INSERT, UPDATE, etc.)
  • Click the Savebutton to save the new privileges.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Issue a Free Let's Encrypt SSL Certificate in DirectAdmin

Let's Encrypt is a free and automated Certificate Authority that provides SSL certificates to...

Rename an Existing Domain Name in DirectAdmin

Step 1: Log in to DirectAdmin Open your web browser and navigate to your DirectAdmin login...

Powered by WHMCompleteSolution