SHOW CREATE USER
was introduced in MariaDB 10.2.0
SHOW CREATE USER user_name
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.
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 | +------------------------------------------------------------------+
GRANTS/PRIVILEGES
for a user.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-create-user/