In this guide, we’re going to show you how to add a new MySQL user on cPanel. By creating a new user, you can control access to your databases, which is particularly useful when you’re collaborating with a team or wish to enhance the security of your website.
Step 1: Log in to your cPanel
Access your control panel by logging in.
Step 2: Navigate to MySQL Databases
On your cPanel homepage, locate the “Databases” section and click on “MySQL Databases”.
Step 3: Create a New MySQL User
Scroll down to the “MySQL Users” section and find the “Add New User” subsection.
In this section, you’ll need to fill out the following fields:
- Username: Enter a username for your new user after the prefix’s underscore. The username prefix will automatically be your cPanel username, followed by an underscore.
- Password: Enter a strong password for the new user. You can use the “Password Generator” button if you need help coming up with a secure password. Be sure to save this password in a secure location.
- Password (Again): Re-enter the password for confirmation.
Once these fields are filled out, click the “Create User” button.
Step 4: Assign the User to a Database
If you want the new user to have access to a specific database, scroll down to the “Add User To Database” section. Select your newly created user and the database you want them to access from the respective dropdown menus. Click “Add” to continue.
Step 5: Grant Privileges
You’ll now be prompted to grant privileges to the user for the selected database. You can choose to provide “ALL PRIVILEGES” or you can select specific privileges based on what the user needs to do.
After selecting the desired privileges, click on the “Make Changes” button.
Step 6: Confirm the New User
To confirm the user was created and has been assigned correctly, navigate back to the “MySQL Databases” page. In the “Current Users” section, you should see your new user listed along with the database they’ve been assigned to.
Conclusion
Congrats! You’ve successfully added a new MySQL user on cPanel. This new user can now access the database with the permissions you’ve assigned. Always remember to use unique usernames and strong passwords for each MySQL user for enhanced security.