This guide will walk you through the process of creating a new user for your MySQL database using DirectAdmin.
-
Access Your DirectAdmin Account
- Open your web browser and navigate to your DirectAdmin login page.
- Enter your username and password to log in.
-
Locate MySQL Management
- In the Account Manager section, look for the MySQL Management icon.
- Alternatively, type "MySQL Management" in the navigation filter box and select it from the results.
-
Select the Target Database
- Once in MySQL Management, you'll see a list of your databases.
- Click on the database for which you want to create a new user.
-
Initiate User Creation
- In the Users section, locate and click on the "Create New User" button.
-
Set Up the New User
- Enter a username in the designated field.
- For the password, you have two options:
- Enter a strong password of your choice in the password field.
- Click on the "Generate New Password" icon to create a random, secure password.
- After entering or generating the password, click on the "Create" button.
-
Secure the New User Details
- Once the user is created, you'll see a confirmation message with the user details.
- Copy and store these details (especially the username and password) in a secure location.
Important Notes:
- Choose a unique and strong username that's not easily guessable.
- If you generate a random password, make sure to copy it immediately as it may not be displayed again.
- Consider using a password manager to securely store the database user credentials.
- Remember to grant appropriate privileges to this new user for the database operations they need to perform.
By following these steps, you can successfully create a new MySQL database user through DirectAdmin. This user can then be granted specific privileges as needed for your database operations.
