How to Add a User to a Database and Grant Privileges
Learn how to add a user to a database in cPanel and grant them the necessary privileges for effective database management.
Follow these steps to add a user to a database and grant privileges in cPanel:
Log in to your cPanel account.
In the Databases section, click on MySQL Databases.

Scroll down to the end of the page and under Add User to Database, select a user from the drop-down list and choose a database from the list.
Click on Add.

In the Manage User Privileges section, mark the box for ALL PRIVILEGES and click on Make Changes.

You have successfully added the user to the database and granted the necessary privileges.
PreviousHow to Create a Database Username in cPanelNextHow to Import a Database via phpMyAdmin in cPanel
Last updated
Was this helpful?