RENAME USER
Syntax
RENAME USER old_user TO new_user [, old_user TO new_user] ...
Description
The RENAME USER statement renames existing MariaDB accounts. To use it,
you must have the global CREATE USER privilege
or the UPDATE
privilege for the mysql
database.
Each account is named using the same format as for the CREATE USER
statement; for example, 'jeffrey'@'localhost'
.
If you specify only the user name part of the account name, a host
name part of '%'
is used.
If any of the old user accounts do not exist or any of the new user accounts already
exist, ERROR 1396 (HY000)
results. If an error occurs, RENAME USER
will still rename the accounts that do not result in an error.
For modifying an existing account, see ALTER USER.
Examples
CREATE USER 'donald', 'mickey'; RENAME USER 'donald' TO 'duck'@'localhost', 'mickey' TO 'mouse'@'localhost';
Renaming the host component of a user
RENAME USER 'foo'@'1.2.3.4' TO 'foo'@'10.20.30.40';
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.