DROP USER user [, user] ...
For example:
DROP USER 'jeffrey'@'localhost';
The host name part of the account name, if omitted, defaults to '%'.
'%'
13.7.1.3 DROP USER Statement