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.

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.

On Manage User Privileges, mark the box ALL PRIVILEGES and click on Make Changes.

Updated on: 14/02/2023
Thank you!