Thursday, August 28, 2025
HomeGuest BlogsHow to Delete or Remove Users MySQL Command line on Linux

How to Delete or Remove Users MySQL Command line on Linux

To remove or delete user MySQL command line Linux; In this tutorial, you will learn step by step on how to delete or remove user from MySQL database in Linux.

MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. The User and Host columns store the user name and host name. This table also indicates which global privileges the account has.

To delete a MySQL user is to remove an account and its privileges from all grant tables. Only users with global CREATE USER or DELETE privileges can perform such tasks. In this tutorial, learn how to delete MySQL user accounts using the DROP USER statement.

Prerequisites for access denied for How To Delete or Remove a MySQL User Account on Linux:

  • Access to a command line or terminal
  • MySQL or MariaDB installed
  • User with sudo or root privileges

How To Delete or Remove a MySQL User Account on Linux Ubuntu

Use the following steps to delete user in mysql ubuntu using command line:

  • Step 1 – Login as Root user MySQL
  • Step 2 – Find user in MySQL
  • Step 3 – Delete Remove User in MySQL
  • Step 4 – Check MySQL User

Step 1 – Login as Root user MySQL

Installed MySQL and try to access phpmyadmin on the local/server machine with the root user, the command you use is:

mysql -u root -p

In most cases, you will receive the error message Access denied for user ‘root’@’localhost’.

You can enable access for root using one MySQL command.

To be able to log into MySQL as root, first use sudo to modify the root user:

sudo mysql

Enter your password at the prompt. A MySQL shell loads.

Step 2 – Find user in MySQL

Execute the following command on terminal to find the exact name of the user you want to remove by running a command that lists users from the MySQL server:

SELECT User, Host FROM mysql.user;

The above command will displays all users.

Step 3 – Delete Remove User in MySQL

Before exeucte the following command, Replace username in the following command with your user:

DROP USER '<em>username</em>'@'host';

Step 4 – Check MySQL User

Execute the following command on terminal recheck the user list to verify the user was deleted:

SELECT User, Host FROM mysql.user;

Conclusion

In this tutorial, you have learned how to solve access denied for user ‘root’@’localhost’ (using password yes) mysql phpmyadmin ubuntu 18.04/20.04.

Recommended Linux/Ubuntu Tutorials

RELATED ARTICLES

Most Popular

Dominic
32236 POSTS0 COMMENTS
Milvus
80 POSTS0 COMMENTS
Nango Kala
6609 POSTS0 COMMENTS
Nicole Veronica
11779 POSTS0 COMMENTS
Nokonwaba Nkukhwana
11828 POSTS0 COMMENTS
Shaida Kate Naidoo
6719 POSTS0 COMMENTS
Ted Musemwa
7002 POSTS0 COMMENTS
Thapelo Manthata
6678 POSTS0 COMMENTS
Umr Jansen
6690 POSTS0 COMMENTS