Syntax:
SHOW CREATE USER user

This statement shows the CREATE USER statement that creates the named
user. An error occurs if the user does not exist. The statement
requires the SELECT privilege for the mysql database, except to see the
privileges for the current user.

To name the account, use the format described in
http://dev.mysql.com/doc/refman/5.7/en/account-names.html. The host
name part of the account name, if omitted, defaults to '%'. It is also
possible to specify CURRENT_USER or CURRENT_USER() to refer to the
account associated with the current session.

URL: http://dev.mysql.com/doc/refman/5.7/en/show-create-user.html

