📣

TiDB Cloud Serverless 现已更名为
Starter
!此页面由 AI 自动翻译,英文原文请见
此处。

RENAME USER

RENAME USER 用于重命名现有用户。

概要

RenameUserStmt
RENAMEUSERUserToUser,
UserToUser
UsernameTOUsername
Username
StringName@StringNamesingleAtIdentifierCURRENT_USEROptionalBraces

示例

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 完全兼容。如果你发现任何兼容性差异,可以 report a bug

相关链接

文档内容是否有帮助?