How To Remove a User from a MySQL Database in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to remove a user from a database.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-7-removeuser-02

  4. In the table of databases, locate the database you wish to remove a user from, locate the specific user assigned to that database that you want to remove and click the delete icon.

    cpanel-pl-mysql-7-removeuser-04

  5. Click "Revoke User Privileges from Database" to confirm.

    cpanel-pl-mysql-7-removeuser-05

  6. That’s it! The user has been removed from the database.

    cpanel-pl-mysql-7-removeuser-06

  7. The user hasn’t been deleted … you can see it’s still listed in the list of current users. It has simply been removed from that database.

    cpanel-pl-mysql-7-removeuser-07

 

Be Sociable, Share!
Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support