How to add a user and his privileges to a database?
Here are the steps to add a user and his privileges to a database:
Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area.
In the Databases section, click on MySQL Databases Icon.
![](https://www.ex2.com/clients/img/mysql-databases-icon.gif)
Scroll down to the end of the page and under Add User to Database, select a user from the dropdown list, and then choose a Database from the list.
Click on the Add button.
![](https://www.ex2.com/clients/img/add-db.gif)
On Manage User Privileges, mark the box ALL PRIVILEGES and click on Make Changes.
![](https://www.ex2.com/clients/img/add-privileges.gif)
Updated on: 14/02/2023
Thank you!