25th Anniversary Savings | 25% Off Dedicated Servers*Shop Now
25th Anniversary Savings | 25% Off VPS Hosting* †††Shop Now
Limited Inventory: High-Performance AMD-Powered Servers Now Available.* Shop Now >

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

PHP 7 vs PHP 8: A Comparison

Read Article

How to Create a Symbolic Link

Read Article

What Is A Private VPS Parent?

Read Article

Managed Hosting vs Unmanaged VPS Hosting

Read Article

Why Is Your IP Address Blocked?

Read Article