Before you begin
You will need:
A cPanel account with the appropriate permissions to manage MySQL databases.
The name of the MySQL user you wish to remove.
The name of the database from which you want to remove the user.
Remove a MySQL User from a Database
Log in to your cPanel account.
Locate the Databases section and select MySQL® Databases.
Scroll down to the Current Databases section.
Find the database you want to modify and locate the More (or Manage) action for that specific database.
Click on Privileges (or Manage Privileges) for the target database.
Locate the user you want to remove from the list of users with access to this database.
Click the Remove (or Delete) icon or button next to that specific user.
Confirm the removal if prompted by the system.
Confirm the result
The user will no longer appear in the list of users with privileges for that specific database.
The user will receive an "Access Denied" error if they attempt to log in to that specific database.
If the user still appears in the list
If the user remains in the list after you have performed the removal steps, clear your browser cache and refresh the page. If the issue persists, the user may have been assigned permissions through a different database or a different account.
Limitations
Removing a user from a database only removes their access to that specific database. This action does not delete the MySQL user's account or their access to other databases they may have been assigned to.
