Summary: in this tutorial, you will learn how to use the MySQL
DROP USER statement to remove one or more user accounts from the database.
Introduction to MySQL
DROP USER statement
To remove a user account from the MySQL Server, you use the
DROP USER statement as follows:
In this syntax, you specify the name of the user account that you want to remove after the
DROP USER keywords.
If you want to remove multiple user accounts at once, you specify a list of comma-separated user accounts in the
DROP USER clause:
If you remove a user account that doesn’t exist, MySQL will issue an error.
In MySQL 5.7.8+, you can use the
IF EXISTS clause to conditionally drop a user only if it exists:
Besides removing the user account, the
DROP USER statement also removes all privileges of the user from all grant tables.
DROP USER examples
Let’s take some examples of dropping users.
A) Using MySQL
DROP USER statement to drop a user example
First, connect to the MySQL Server using the
Type the password for the
root user and press
Second, create four account users
Third, show users from the MySQL Server:
Here is the current user list:
Fourth, drop the user
dbadmin@localhost by using the
DROP USER statement:
Fifth, show all users again:
The user account
dbadmin@localhost has been removed successfully.
B) Using MySQL
DROP USER to drop multiple user accounts at once
First, remove two user accounts
remote using the following statement:
Second, show users from the current database:
Here is the output:
C) Using MySQL
DROP USER to drop a connected user
First, create a new database called