DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) show-grants

Info Catalog (mysql.info) show-errors (mysql.info) show (mysql.info) show-index
 
 13.5.4.12 `SHOW GRANTS' Syntax
 ..............................
 
      SHOW GRANTS FOR USER
 
 This statement lists the `GRANT' statement or statements that must be
 issued to duplicate the privileges that are granted to a MySQL user
 account. The account is named using the same format as for the `GRANT'
 statement; for example, `'jeffrey'@'localhost''. The user and host
 parts of the account name correspond to the `User' and `Host' column
 values of the `user' table row for the account.
 
      mysql> SHOW GRANTS FOR 'root'@'localhost';
      +---------------------------------------------------------------------+
      | Grants for root@localhost                                           |
      +---------------------------------------------------------------------+
      | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
      +---------------------------------------------------------------------+
 
 To list the privileges granted to the account that you are using to
 connect to the server, you can use any of the following statements:
 
      SHOW GRANTS;
      SHOW GRANTS FOR CURRENT_USER;
      SHOW GRANTS FOR CURRENT_USER();
 
 `SHOW GRANTS' displays only the privileges granted explicitly to the
 named account. Other privileges might be available to the account, but
 they are not displayed.  For example, if an anonymous account exists,
 the named account might be able to use its privileges, but `SHOW
 GRANTS' will not display them.
 
Info Catalog (mysql.info) show-errors (mysql.info) show (mysql.info) show-index
automatically generated byinfo2html