RENAME USER
RENAME USER 语句用于对已有用户进行重命名。
语法图
- RenameUserStmt
- UserToUser
- Username
示例
CREATE USER 'newuser' IDENTIFIED BY 'mypassword';Query OK, 1 row affected (0.02 sec)SHOW GRANTS FOR 'newuser';+-------------------------------------+
| Grants for newuser@% |
+-------------------------------------+
| GRANT USAGE ON *.* TO 'newuser'@'%' |
+-------------------------------------+
1 row in set (0.00 sec)RENAME USER 'newuser' TO 'testuser';Query OK, 0 rows affected (0.08 sec)SHOW GRANTS FOR 'testuser';+--------------------------------------+
| Grants for testuser@% |
+--------------------------------------+
| GRANT USAGE ON *.* TO 'testuser'@'%' |
+--------------------------------------+
1 row in set (0.00 sec)SHOW GRANTS FOR 'newuser';ERROR 1141 (42000): There is no such grant defined for user 'newuser' on host '%'MySQL 兼容性
RENAME USER 语句与 MySQL 完全兼容。如发现任何兼容性差异，请尝试 TiDB 支持资源。