MySQL in a Nutshell, 2nd Edition

Name

SHOW GRANTS

Synopsis

SHOW GRANTS [FOR 'user'[@'host']]

This SQL statement displays the GRANT statement for a given user. If the FOR clause is not given, the current user account is assumed. If the username is given without reference to a particular host, the wildcard % is assumed. Otherwise, the username should be followed by the host as shown here:

SHOW GRANTS FOR 'russell'@'localhost'\G

*************************** 1. row ***************************
Grants for russell@localhost: 

GRANT ALL PRIVILEGES ON *.* 
TO 'russell'@'localhost' 
IDENTIFIED BY PASSWORD '57fa103a3c5c9f30' 
WITH GRANT OPTION

The resulting statement is what would be entered to create the user russell for the host localhost, with the given privileges including the WITH GRANT OPTION flag.