Creating a database username in cPanel is essential for managing access to your databases.
Follow these steps to create a new database username and assign it to a database:
Step 1: Log in to cPanel
- Open your web browser and navigate to your cPanel login page (e.g.,
https://yourdomain.com:2083). - Enter your username and password, then click Log in.
Step 2: Access the MySQL Databases Tool
- Scroll down to the Databases section in the cPanel dashboard.
- Click on MySQL Databases.
Step 3: Create a New Database User
- In the MySQL Users section, look for the Add New User form.
- Fill in the following details:
- Username: Enter a unique username for the database user.
- Example: If you enter
dbuser, the full username will becpanelUsername_dbuser.
- Example: If you enter
- Password: Enter a strong password for the user.
- Use the Password Generator to create a secure password.
- Password (Again): Re-enter the password to confirm it.
- Username: Enter a unique username for the database user.
- Click Create User.
Step 4: Assign the User to a Database
- After creating the user, scroll to the Add User to Database section.
- Select the new database username from the User dropdown menu.
- Select the database to which you want to assign the user from the Database dropdown menu.
- Click Add.
Step 5: Set Privileges for the User
- After adding the user to the database, you’ll be directed to the Manage User Privileges page.
- Choose the privileges to assign to the user:
- All Privileges: Grants full access to the database (recommended for most cases).
- Specific Privileges: Select only the permissions needed (e.g., SELECT, INSERT, UPDATE).
- Click Make Changes to save.
Step 6: Verify the User
- Return to the MySQL Databases page.
- Confirm that the new user is listed under the Current Users section and associated with the correct database.
Tips for Managing Database Users
- Use Strong Passwords: Ensure passwords are secure to prevent unauthorized access.
- Backup Credentials: Save the username and password in a secure location.
- Assign Permissions Wisely: Grant only the permissions needed for the user’s tasks to enhance security.
By creating a database username and assigning it to a database in cPanel, you ensure secure and controlled access for your website or applications.
