Manage MySQL databases with DirectAdmin

This KB article is for DirectAdmin for shared hosting (end-users).

Sooner or later, you will need databases for your site. You can configure MySQL databases and users very easily from the DirectAdmin interface.

DirectAdmin MySQL Management
DirectAdmin MySQL Management Window

To create a new database and a new user for it in DIrectAdmin:

  1. Log into DirectAdmin
  2. Navigate to MYSQL Management
  3. Click the Create new Database link
  4. Enter the database name, the database user you want to add to it, and the password for the user.
    Notice that database names and user names will begin with the DirectAdmin username followed by an underscore, like directadminusername_dbname, directadminusername_dbusername
  5. Click the Create button. The database and user will be created, you will see a confirmation message: Database Created

With this tool you can also Repair, Check and Optimize databases. Just select the database(s) and click the button for your intended action.

You can use this tool for both MySQL and MariaDB servers.

Youtube tutorial for this post: