How to Assign/Unassign a MySQL User to a Database

Assign User Privileges to a Database

  • Log into cPanel

cPanel Login


  • Under Databases, click MySQL Databases

MySQL Databases


  • Under Add User to Database, select a user from the User drop-down menu
  • From the Database drop-down menu, select the database to which you wish to allow the user access
  • Click Add

Add User


  • From the MySQL Account Maintenance screen, select the privileges you wish to grant the user or select 'ALL PRIVILEGES'
  • Click 'Make Changes'
Assign Privileges

Unassign User Privileges to a Database

  • Navigate to the Current Databases section of MySQL Databases

Current DBs


  • Navigate to the database you wish to modify
  • In the Users column for that database, click the bin icon next to the user you wish to delete
Delete User

Was this answer helpful?

 Print this Article

Also Read

How to Backup Entire Site in cPanel

You can backup your entire site including databases, e-mails, settings etc using the cPanel...

How to Change your cPanel Password in cPanel

Often you may want to change your cPanel password for one or more reasons. It is always...

Terminated Service

Your services with us are mostly provided on a subscription basis, to be renewed on/before expiry...

How to Disable APC Cache via .htaccess

You can disable APC Caching for your domain via .htaccess with the following steps: Login to...

How to Change cPanel Password in the Core

Often, you may want to change your cPanel password. You can do this from your core panel. To...