MySQL How to delete a user in MySQL

Deleting a MySQL user is simple and can be done using the DROP USER statement.

List the users

First of all, list the MySQL users:

SELECT User, Host FROM mysql.user;

Delete a MySQL user

DROP USER 'mario'@'localhost';

Delete multiple MySQL users

DROP USER 'mario'@'localhost', 'luigi'@'localhost';