📣

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

SHOW CREATE USER

此语句显示如何使用 CREATE USER 语法重新创建用户。

概要

ShowCreateUserStmt
SHOWCREATEUSERUsername@HostnameCURRENT_USER()

示例

mysql> SHOW CREATE USER 'root'; +--------------------------------------------------------------------------------------------------------------------------+ | CREATE USER for root@% | +--------------------------------------------------------------------------------------------------------------------------+ | CREATE USER 'root'@'%' IDENTIFIED WITH 'mysql_native_password' AS '' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK | +--------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW GRANTS FOR 'root'; +-------------------------------------------+ | Grants for root@% | +-------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' | +-------------------------------------------+ 1 row in set (0.00 sec)

MySQL 兼容性

  • SHOW CREATE USER 的输出旨在与 MySQL 保持一致,但 TiDB 目前尚不支持部分 CREATE 选项。不支持的选项会被解析但忽略。更多详情请参见 Security compatibility

相关链接

文档内容是否有帮助?