Syntax
------

SHOW CREATE USER [user]

Description
-----------

Shows the CREATE USER statement that creates the given user. The statement
requires the SELECT privilege for the mysql database, except for the current
user. The CREATE USER statement for the current user is shown where no user is
specified.

SHOW CREATE USER quotes identifiers according to the value of the
sql_quote_show_create system variable.

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'

User Password Expiry:

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 |
+------------------------------------------------------------------+

URL: https://mariadb.com/kb/en/show-create-user/