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.

remove a MySQL user from a database

3.  Click MySQL® Databases.

The MySQL® Databases page will be displayed.

Scroll down to the section,Current Databases.

MySQL® Databases page

4.  Click Delete (trash icon) 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.

Revoke MySQL Privileges from Database

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.

How can we help you?

We want you to ask us questions, because we love to help you in accomplishing your goals. We let no questions unanswered, provide you with high speed responses and leave no problem unsolved. What is important to you, is important to us. Shoot us a message and see for yourself.