SHOW CREATE USER
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.2.0
SHOW CREATE USER
was introduced in MariaDB 10.2.0
Syntax
SHOW CREATE USER user_name
Description
Shows the CREATE USER
statement that created the given
user. The statement requires the SELECT
privilege for the mysql
database, except for the current user.
Examples
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'
See also
CREATE USER
ALTER USER
SHOW GRANTS
shows theGRANTS/PRIVILEGES
for a user.SHOW PRIVILEGES
shows the privileges supported by 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.