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.