Skip to main content

How to Change a MySQL User's Database Privileges

Change the permissions of a specific MySQL user for a database within your cPanel account. This allows you to control what actions a specific database user can perform, such as selecting, inserting, or deleting data.

Change the permissions of a specific MySQL user for a database within your cPanel account. This allows you to control what actions a specific database user can perform, such as selecting, inserting, or deleting data.

Before you begin

You will need:

  • A cPanel account

  • The name of the MySQL database

  • The username of the MySQL user

  • Administrative access to the cPanel interface

Adjusting MySQL User Privileges

  1. Log in to your cPanel account.

  2. Locate the Databases section and select MySQL® Databases.

  3. Scroll down to the MySQL Databases section.

  4. Find the specific database and user you wish to modify in the list.

  5. Click the Privileges icon (or link) located next to the specific user associated with that database.

  6. On the Add Privileges page, you will see a list of available permissions.

  7. Select the specific privileges you want to grant or revoke.

  8. Click Make Changes (or Go) at the bottom of the page to apply the updates.

Confirm the result

  • The page will refresh and display a success message confirming the privileges were updated.

  • The specific MySQL user will now only have the permissions you selected when attempting to connect to the database.

Limitations

This process only changes the permissions for the specific user selected. If you have multiple users for the same database, you must update each user individually. These changes take effect immediately.

Did this answer your question?