DROP USER Statement

DROP USER user [, user] ...

For example:

DROP USER 'jeffrey'@'localhost';

The host name part of the account name, if omitted, defaults to '%'.

References