Let's look at how to drop a user in MySQL using the DROP USER statement.
In this example, the DROP USER statement would drop the user called ao in the MySQL database.
Drop more than one user
How can you drop more than one user at a time in MySQL? You can use the DROP USER statement to drop multiple users by comma separating the users that you wish to drop.
This DROP USER example would drop two users in MySQL - ao and andersonk.