Syntax\n------\n\nSHOW CREATE USER [user-name]\n\nDescription\n-----------\n\nShows 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.\n\nSHOW CREATE USER quotes identifiers according to the value of the sql_quote_show_create system variable.\n\nExamples\n--------\n\nCREATE USER foo4@test require cipher 'text' \n  issuer 'foo_issuer' subject 'foo_subject';\n\nSHOW CREATE USER foo4@test\\G\n************************ 1. row ************************\nCREATE USER 'foo4'@'test' \n  REQUIRE ISSUER 'foo_issuer' \n  SUBJECT 'foo_subject' \n  CIPHER 'text'\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-user