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.

The account name uses the format described in
http://dev.mysql.com/doc/refman/5.7/en/account-names.html. If you
specify only the user name part of the account name, a host name part
of '%' is used. 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

