(mysql.info) rename-user

情報カタログ

(mysql.info) grant

(mysql.info) account-management-sql

(mysql.info) revoke

 
 13.5.1.4 `RENAME USER' Syntax
 .............................
 
      RENAME USER OLD_USER TO NEW_USER
          [, OLD_USER TO NEW_USER] ...
 
 The `RENAME USER' statement renames existing MySQL accounts. To use it,
 you must have the global `CREATE USER' privilege or the `UPDATE'
 privilege for the `mysql' database. An error occurs if any old account
 does not exist or any new account exists. 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.
 
 The `RENAME USER' statement was added in MySQL 5.0.2.
 

情報カタログ

(mysql.info) grant

(mysql.info) account-management-sql

(mysql.info) revoke