Search Knowledge Base by Keyword

How to Manage Database Users in cPanel

Creating and Managing Databases using MySQL in cPanel is very straightforward. To access MySQL, the user first need to create users.In MySQL, users are added to the database and assigned relevant usernames and passwords. Let’s look at managing database users in cPanel.

First, login to cPanel.

Now navigate to MySQL databases, in the Databases section.

MySQL databases option in cPanel

Now scroll down to the MySQL Users section.

adding new user screen to MySQL databases in cPanel

Adding a new user

To add a new user, enter the username and password in the Add New User section.

Then click Create User to finish setting up the user.

adding new database user in cPanel

Deleting a user

To delete a user, navigate to the Current Users section, scroll down to the user in question, and click the Delete link beside the username.

deleting database user in cPanel

Adding a user to a database

To add a user to a database on your hosting account, just scroll down to the Add User To Database section, select the user and the database, then click Add.

adding user to database in cPanel

Changing a database user password

To change the password for a database user, just scroll down to the Current Users section, then click Change Password beside the database user.

change database user password option in cPanel

Then just enter and confirm the new password, and click Change Password to finish setting the new password.

Renaming a database user

To rename a database user, scroll down to the Current Users section, then click Rename beside the database user.

renaming database user option in cPanel

Then just enter the new username and click Proceed to finish renaming the database user.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.