Sign InTry Free

SHOW CREATE USER

This statement shows how to re-create a user using the CREATE USER syntax.

Synopsis

ShowCreateUserStmt:

ShowCreateUserStmt

Username:

Username

Examples

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 compatibility

  • The output of SHOW CREATE USER is designed to match MySQL, but several of the CREATE options are not yet supported by TiDB. Not yet supported options will be parsed but ignored. See [security compatibility] for more details.

See also

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.