DROP USER

Purpose

You can use this statement to drop one or more database users.

Notice

• To execute this statement, you must have the global CREATE USER privilege.
• You can drop the mysql.user table only by performing the DROP operation, but not the DELETE operation.
• After you drop a user, all its privileges are dropped along with it.

Syntax

DROP USER user_name [, user_name...];

Parameters

Examples

Delete a user named sqluser01.

obclient>DROP USER sqluser01;
Query OK, 0 rows affected (0.02 sec)