(mysql.info) drop-user

Info Catalog

(mysql.info) create-user

(mysql.info) account-management-sql

(mysql.info) grant

 
 13.5.1.2 `DROP USER' Syntax
 ...........................
 
      DROP USER USER [, USER] ...
 
 The `DROP USER' statement removes one or more MySQL accounts. To use
 it, 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.
 
 `DROP USER' as present in MySQL 5.0.0 removes only accounts that have
 no privileges. In MySQL 5.0.2, it was modified to remove account
 privileges as well. This means that the procedure for removing an
 account depends on your version of MySQL.
 
 As of MySQL 5.0.2, you can remove an account and its privileges as
 follows:
 
      DROP USER USER;
 
 The statement removes privilege rows for the account from all grant
 tables.
 
 In MySQL 5.0.0 and 5.0.1, `DROP USER' deletes only MySQL accounts that
 have no privileges. In these MySQL versions, it serves only to remove
 each account record from the `user' table. To remove a MySQL account
 completely (including all of its privileges), you should use the
 following procedure, performing these steps in the order shown:
 
   1. Use `SHOW GRANTS' to determine what privileges the account has. See
       show-grants.
 
   2. Use `REVOKE' to revoke the privileges displayed by `SHOW GRANTS'.
      This removes rows for the account from all the grant tables except
      the `user' table, and revokes any global privileges listed in the
      `user' table.  See  grant.
 
   3. Delete the account by using `DROP USER' to remove the `user' table
      record.
 
 _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_.
 

Info Catalog

(mysql.info) create-user

(mysql.info) account-management-sql

(mysql.info) grant