How to Add a User to a Database and Grant Privileges

When managing a database in cPanel, it is important to add a user and set the right permissions for secure access. It ensures that only authorized users can make changes or retrieve data, keeping your websites database safe.

1. Log in to your cPanel account.

2. In the Databases section, click on Manage My Databases.


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

4. Click on Add.


5. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.

We hope this tutorial is helpful to you.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Create a Database in cPanel

Creating a database in cPanel is quick and straightforward. Follow these steps to set up your...

How to Rename a Database in cPanel

Creating a database in cPanel is quick and straightforward. Follow these steps to set up your...

How to Create a Database Username in cPanel

A database username is important for connecting your website or application to the database. You...

How to Delete a Database in cPanel

You can delete a database in cPanel. Make sure to take a backup before deleting it because once...

How to Import a Database via phpMyAdmin in cPanel

Importing a database in cPanel using phpMyAdmin is a quick way to restore or migrate your data....