How to create a MySQL database in DirectAdmin

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

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

1. Log in to your DirectAdmin control panel by accessing https://yourdomain:2222
2. Navigate to MYSQL Management(underAccount Management)
3. Click the Create New Databasebutton
4. Enter the database name, the database user you want to add, and the user’s password.
   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 Createbutton. 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.