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](https://www.ukhost4u.com/wp-content/uploads/2020/03/tempsnip-26-1024x99.png)
Now scroll down to the MySQL Users section.
![adding new user screen to MySQL databases in cPanel](https://www.ukhost4u.com/wp-content/uploads/2020/03/image-81-1024x636.png)
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](https://www.ukhost4u.com/wp-content/uploads/2020/03/tempsnip-27.png)
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](https://www.ukhost4u.com/wp-content/uploads/2020/03/tempsnip-28.png)
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](https://www.ukhost4u.com/wp-content/uploads/2020/03/tempsnip-29.png)
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](https://www.ukhost4u.com/wp-content/uploads/2020/03/tempsnip-30.png)
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](https://www.ukhost4u.com/wp-content/uploads/2020/03/tempsnip-31.png)
Then just enter the new username and click Proceed to finish renaming the database user.