13.5.1.2. DROP USER Syntax
DROP USER user [, user] ...
The DROP USER statement removes one or more
MySQL accounts. It removes privilege rows for the account from
all grant tables. To use this statement, you must have the
global CREATE USER privilege or the
DELETE privilege for the
mysql database. Each account is named using
the same format as for the GRANT statement;
for example, 'jeffrey'@'localhost'. The
user and host parts of the account name correspond to the
User and Host column
values of the user table row for the
account.
With DROP USER, you can remove an account
and its privileges as follows:
DROP USER user;
Important: DROP USER
does not automatically close any open user sessions. Rather,
in the event that a user with an open session is dropped, the
statement does not take effect until that user's session is
closed. Once the session is closed, the user is dropped, and
that user's next attempt to log in will fail. This
is by design.
