RENAME USER

RENAME USER 语句用于对已有用户进行重命名。

语法图

RenameUserStmt

RENAME USER - 图1

UserToUser

RENAME USER - 图2

Username

RENAME USER - 图3

1. RenameUserStmt ::=
2. 'RENAME' 'USER' UserToUser ( ',' UserToUser )*

4. UserToUser ::=
5. Username 'TO' Username

7. Username ::=
8. StringName ('@' StringName | singleAtIdentifier)? | 'CURRENT_USER' OptionalBraces

示例

1. CREATE USER 'newuser' IDENTIFIED BY 'mypassword';

1. Query OK, 1 row affected (0.02 sec)

1. SHOW GRANTS FOR 'newuser';

1. +-------------------------------------+
2. | Grants for newuser@%                |
3. +-------------------------------------+
4. | GRANT USAGE ON *.* TO 'newuser'@'%' |
5. +-------------------------------------+
6. 1 row in set (0.00 sec)

1. RENAME USER 'newuser' TO 'testuser';

1. Query OK, 0 rows affected (0.08 sec)

1. SHOW GRANTS FOR 'testuser';

1. +--------------------------------------+
2. | Grants for testuser@%                |
3. +--------------------------------------+
4. | GRANT USAGE ON *.* TO 'testuser'@'%' |
5. +--------------------------------------+
6. 1 row in set (0.00 sec)

1. SHOW GRANTS FOR 'newuser';

1. ERROR 1141 (42000): There is no such grant defined for user 'newuser' on host '%'

MySQL 兼容性

RENAME USER 语句与 MySQL 完全兼容。如发现任何兼容性差异，请尝试 TiDB 支持资源。

另请参阅