How do I remove a MySQL user from a database?
Removing a user and their credentials from the MySQL is straightforward. It usually makes use of a simple command in any query language. In this case, cPanel has the options to do it under Databases section. However, caution is to be exercised while doing this since all of the user’s privileges are withdrawn and the user can no longer have access to any portion of the database.
Also, you need to have global user credentials to modify or manipulate the database with such changes.
1. Log in to your cPanel account.
2. Navigate to Databases.
The Database section will be displayed.
3. Click MySQL® Databases.
The MySQL® Databases page will be displayed.
Scroll down to the section,Current Databases.
4. Click Delete () in the row of the database for which you wish to remove the user privilege, under the Privileged Users column.
The Revoke MySQL Privileges from Database will be displayed.
5. Click Revoke MySQL Privileges from Database.
The user privileges to the database will be removed. In other words, the user can no longer access this database.