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.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.