SHOW CREATE USER
语法
SHOW CREATE USER user_name
描述
显示创建给定用户的 CREATE USER 语句。该语句需要 SELECT 权限以访问 mysql 数据库,但当前用户除外。
示例
CREATE USER foo4@test require cipher 'text' issuer 'foo_issuer' subject 'foo_subject'; SHOW CREATE USER foo4@test\G *************************** 1. row *************************** CREATE USER 'foo4'@'test' REQUIRE ISSUER 'foo_issuer' SUBJECT 'foo_subject' CIPHER 'text'
CREATE USER 'monty'@'localhost' PASSWORD EXPIRE INTERVAL 120 DAY; SHOW CREATE USER 'monty'@'localhost'; +------------------------------------------------------------------+ | CREATE USER for monty@localhost | +------------------------------------------------------------------+ | CREATE USER 'monty'@'localhost' PASSWORD EXPIRE INTERVAL 120 DAY | +------------------------------------------------------------------+
参见
- CREATE USER
- ALTER USER
- SHOW GRANTS 显示用户的
GRANTS/PRIVILEGES
。 - SHOW PRIVILEGES 显示 MariaDB 支持的权限。
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.