(mysql.info) revoke

Info Catalog

(mysql.info) rename-user

(mysql.info) account-management-sql

(mysql.info) set-password

 
 13.5.1.5 `REVOKE' Syntax
 ........................
 
      REVOKE PRIV_TYPE [(COLUMN_LIST)] [, PRIV_TYPE [(COLUMN_LIST)]] ...
          ON [OBJECT_TYPE] {TBL_NAME | * | *.* | DB_NAME.*}
          FROM USER [, USER] ...
 
      REVOKE ALL PRIVILEGES, GRANT OPTION FROM USER [, USER] ...
 
 The `REVOKE' statement enables system administrators to revoke
 privileges from MySQL accounts. To use `REVOKE', you must have the
 `GRANT OPTION' privilege, and you must have the privileges that you are
 revoking.
 
 For details on the levels at which privileges exist, the allowable
 PRIV_TYPE values, and the syntax for specifying users and passwords, see
  grant
 
 If the grant tables hold privilege rows that contain mixed-case
 database or table names and the `lower_case_table_names' system
 variable is set to a non-zero value, `REVOKE' cannot be used to revoke
 these privileges. It will be necessary to manipulate the grant tables
 directly.  (`GRANT' will not create such rows when
 `lower_case_table_names' is set, but such rows might have been created
 prior to setting the variable.)
 
 To revoke all privileges, use the following syntax, which drops all
 global, database-, table-, and column-level privileges for the named
 user or users:
 
      REVOKE ALL PRIVILEGES, GRANT OPTION FROM USER [, USER] ...
 
 To use this `REVOKE' syntax, you must have the global `CREATE USER'
 privilege or the `UPDATE' privilege for the `mysql' database.
 

Info Catalog

(mysql.info) rename-user

(mysql.info) account-management-sql

(mysql.info) set-password