- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
DROP USERuser[,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'. If you
specify only the username part of the account name, a hostname
part of '%' is used. For additional
information about specifying account names, see
Section 12.5.1.3, “GRANT Syntax”.
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.
DROP USER does not automatically delete or
invalidate any database objects that the user created. This
applies to tables, views, stored routines, triggers, and
events.
User Comments
Add your own comment.