Unassigning a User from a Database
- Log into cpanel
- Click on 'MySQL Databases' under ' Databases' section.
- Navigate to the Current Databases section of MySQL Databases.
- Locate the database you wish to modify.
- In the Users column for that database, click the delete button next to the user you wish to delete.
- Click on the button 'Revoke User Privileges from Database'.It will remove the user which is assigned to database. You can assign different user to the same database.