Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

13.7.5.12 SHOW CREATE USER Statement

SHOW CREATE USERuser

This statement shows theCREATE USER statement that creates the named user. An error occurs if the user does not exist. The statement requires theSELECT privilege for themysql system database, except to display information for the current user.

To name the account, use the format described inSection 6.2.4, “Specifying Account Names”. The host name part of the account name, if omitted, defaults to'%'. It is also possible to specifyCURRENT_USER orCURRENT_USER() to refer to the account associated with the current session.

mysql> SHOW CREATE USER 'root'@'localhost'\G*************************** 1. row ***************************CREATE USER for root@localhost: CREATE USER 'root'@'localhost'IDENTIFIED WITH 'mysql_native_password'AS '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19'REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK

The output format is affected by the setting of thelog_builtin_as_identified_by_password system variable.

To display the privileges granted to an account, use theSHOW GRANTS statement. SeeSection 13.7.5.21, “SHOW GRANTS Statement”.