25th Anniversary Savings | 25% Off Dedicated Servers*Shop Now
25th Anniversary Savings | 25% Off VPS Hosting* †††Shop Now
Dedicated Hosting Deals | From $99/moShop Now
Earn hosting credits and a chance to win an Amazon gift card when you refer friends to Liquid Web!Read our promo rules

How to Remove a User From a MySQL Database in cPanel

Posted on by Ronald Caldwell | Updated:
Reading Time: 3 minutes

When administering servers and systems, occasionally users need to be removed for security purposes. Only users that need access to databases should maintain credentials. It is the best practice to periodically check that those who should maintain access do, and those that are no longer needed are removed.

This tutorial guides you through the process of how to remove a user from a MySQL database in cPanel.

Requirements

  • A server running cPanel.
  • Login credentials and appropriate permissions in cPanel.
  • Log into cPanel.

How to Remove a User From a MySQL Database in cPanel

1. Log into cPanel.

2. Under Databases, click MySQL Databases.

3. Under Current Databases, locate the specific database and user assigned to that database that you want to remove. Click Delete, which is the trash can icon next to the user.

4. Click Revoke User Privileges from Database to confirm.

5. A green confirmation message appears that the user has been removed from the database.

The user has not been deleted and is still listed under Current Users on the main MySQL Databases page. You have removed the user from the desired database, but it can be deleted or reassigned to another database.

Wrapping Up

Your security checklist should involve how to remove a user from a MySQL database in cPanel if the user is no longer needed. Protecting your data is of utmost importance for your business and users.

As a Liquid Web customer with a fully managed server, you enjoy 24/7/365 support for cPanel. We manage the hardware, control panel, and server stack so you can focus on your core business, websites, and applications. If you are interested in our managed hosting options, contact our sales team to get started today.

Check out the next tutorial in our cPanel and MySQL series on How to Delete a MySQL Database User in cPanel.

About the Author: Ronald Caldwell

Ron is a Technical Writer at Liquid Web working with the Marketing team. He has 9+ years of experience in Technology. He obtained an Associate of Science in Computer Science from Prairie State College in 2015. He is happily married to his high school sweetheart and lives in Michigan with her and their children.

Latest Articles

How to Edit the PHP Memory for Your WordPress Site via WP Toolkit

Read Article

What is CGI-Bin and What Does it Do?

Read Article

Top 10 Password Security Standards

Read Article

Top 10 Password Security Standards

Read Article

How to Use the WP Toolkit to Secure and Update WordPress

Read Article