Deleting a MySQL database user removes that login and its access to databases. This guide explains how to remove a user in cPanel while leaving the databases themselves in place.

Before you start

Check whether any website, scheduled task or other application uses this username. Update those applications to use another appropriately authorised user and test the new connection before removing the old login.

Delete the user

  1. Log in to cPanel and open Databases > Manage My Databases, called MySQL Databases in older versions.
  2. Scroll to Current Users.
  3. Find the exact username and click Delete beside it.
  4. Check that the confirmation names the intended user, then confirm the deletion.
  5. Verify that the user is no longer listed and that the affected applications still connect successfully.

To remove access to just one database while keeping the login, remove that user’s assignment from the database’s privileged users instead of deleting the user account.