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?

Also Read

406 Not Acceptable Error

A 406 Not Acceptable Error is indicating that the script you are trying to run is triggering...

How to Export a MySQL Database

Log in to cPanel   Click phpMyAdmin under the Databases tab On the left...

How to Create a Subdomain

Log in to your cPanel Navigate to Subdomains under the Domains tab Enter the...

Terminated Service

Renewal and Service Maintenance: Our services are subscribed, requiring renewal before the...

How to Create/Delete MySQL Database User

To Create a Database User Log into cPanel   Under Databases, click MySQL Databases...