Event information is also available from the INFORMATION_SCHEMA EVENTS  table. See Section 26.3.14, “The INFORMATION_SCHEMA EVENTS Table” . 

The event action statement is not shown in the output of SHOW EVENTS . Use SHOW CREATE EVENT  or the INFORMATION_SCHEMA EVENTS  table. 

## 13.7.7.19 SHOW FUNCTION CODE Statement 

SHOW FUNCTION CODE func_name 

This statement is similar to SHOW PROCEDURE CODE  but for stored functions. See Section 13.7.7.27, “SHOW PROCEDURE CODE Statement” . 

## 13.7.7.20 SHOW FUNCTION STATUS Statement 

SHOW FUNCTION STATUS [LIKE ’ pattern ’ | WHERE expr ] 

This statement is similar to SHOW PROCEDURE STATUS  but for stored functions. See Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement” . 

## 13.7.7.21 SHOW GRANTS Statement 

SHOW GRANTS [FOR user_or_role [USING role  [, role ] ...]] user_or_role : { user  (see Section 6.2.4, “Specifying Account Names” ) | role  (see Section 6.2.5, “Specifying Role Names” . } 

This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT  statements that must be executed to duplicate the privilege and role assignments. 

## Note 

To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER  statement. See Section 13.7.7.12, “SHOW CREATE USER Statement” . 

SHOW GRANTS  requires the SELECT  privilege for the mysql  system schema, except to display privileges and roles for the current user. 

To name the account or role for SHOW GRANTS , use the same format as for the GRANT  statement (for example, ’jeffrey’@’localhost’ ): 

mysql> SHOW GRANTS FOR ’jeffrey’@’localhost’; +------------------------------------------------------------------+ | Grants for jeffrey@localhost | +------------------------------------------------------------------+ | GRANT USAGE ON *.* TO ‘jeffrey‘@‘localhost‘ | | GRANT SELECT, INSERT, UPDATE ON ‘db1‘.* TO ‘jeffrey‘@‘localhost‘ | +------------------------------------------------------------------+ 

The host part, if omitted, defaults to ’%’ . For additional information about specifying account and role names, see Section 6.2.4, “Specifying Account Names” , and Section 6.2.5, “Specifying Role Names” . 

To display the privileges granted to the current user (the account you are using to connect to the server), you can use any of the following statements: 

SHOW GRANTS; 

