How to Delete a MySQL User

What is a MySQL user?

A database is a digital filing cabinet that stores your website's data. A MySQL user is like a key holder. It has a name and a password. It lets a person or an app open the database. If you remove the user, that key stops working.

Method 1: cPanel

1. Log in to your hosting control panel (cPanel).
2. Find the Databases section.
3. Click MySQL Databases.
4. Scroll down to Current Users.
5. Find the user you want to remove.
6. Click Delete next to that user.
7. Confirm by clicking Delete User.

   

The database itself stays. Only the user is removed.

Method 2: Command line

This needs SSH access and a MySQL account with admin rights. It is common on a VPS or dedicated server.

1. Connect to your server with SSH.
2. Log in to MySQL:

mysql -u root -p

This opens MySQL and asks for the password.

3. See the list of users:

SELECT User, Host FROM mysql.user;

This shows each user and the place they connect from.

4. Delete the user. Replace the name and host with yours:

DROP USER 'olduser'@'localhost';

This removes the user for that host.

5. Apply the change:

FLUSH PRIVILEGES;

This tells MySQL to reload its list of users.

6. Leave MySQL:

exit;

If you get an error

• "Operation DROP USER failed" usually means the name or host is wrong. Check the list again. Names are case sensitive.
• If the user does not appear in cPanel, it may belong to a different account.

If you are stuck, open a support ticket.

Quick recap

• A MySQL user is a login for a database.
• In cPanel, use MySQL Databases, then Current Users, then Delete.
• On the command line, use DROP USER.
• Back up first and check that no site uses the user.