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.

Last updated

Was this helpful?