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 Backup MySQL Database in cPanel

You can backup any database on your account using the cPanel backup feature Log into cPanel...

How to Create a Subdomain

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

How to Create/Remove an Addon Domain

With Addon Domains, it becomes possible for you to host multiple domain names with different...

How to Run Python Scripts on GigaLayer

All our shared servers are deployed with support for python scripts. However, you need to do a...