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:
example:2222
(replace "example.com" with your actual server's 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 Management
to 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 Database
button 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 User
button to create a new user for the database. -
Enter a username and password for the new database user.
-
Click the
Create
button 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 Privileges
next to the user. -
Grant/Remove the specific privileges for the user (e.g., SELECT, INSERT, UPDATE, etc.)
-
Click the
Save
button to save the new privileges.