SHOW Statements The SQL mode in effect when the trigger was created, and under which the trigger executes. For the permitted values, see Section 5.1.11, “Server SQL Modes” . The account of the user who created the trigger, in  ’ user_name ’@’ host_name ’  format. The session value of the  character_set_client  system variable when the trigger was created. The session value of the  collation_connection  system variable when the trigger was created. The collation of the database with which the trigger is associated. Trigger information is also available from the  INFORMATION_SCHEMA TRIGGERS  table. See Section 26.3.45, “The INFORMATION_SCHEMA TRIGGERS Table” . SHOW VARIABLES  shows the values of MySQL system variables (see Section 5.1.8, “Server System Variables” ). This statement does not require any privilege. It requires only the ability to connect to the server. System variable information is also available from these sources: For  SHOW VARIABLES , a  LIKE  clause, if present, indicates which variable names to match. A  WHERE clause can be given to select rows using more general conditions, as discussed in Section 26.8, “Extensions to SHOW Statements” . SHOW VARIABLES  accepts an optional  GLOBAL  or  SESSION  variable scope modifier: SHOW VARIABLES  is subject to a version-dependent display-width limit. For variables with very long values that are not completely displayed, use  SELECT  as a workaround. For example: The scope for each system variable is listed at Section 5.1.8, “Server System Variables” . 2964 •If no modifier is present, the default is  SESSION . •With a  SESSION  modifier, the statement displays the system variable values that are in effect for the current connection. If a variable has no session value, the global value is displayed.  LOCAL  is a synonym for  SESSION . •With a  GLOBAL  modifier, the statement displays global system variable values. These are the values used to initialize the corresponding session variables for new connections to MySQL. If a variable has no global value, no value is displayed. •The  mysqladmin variables  command. See Section 4.5.2, “mysqladmin — A MySQL Server Administration Program” . •Performance Schema tables. See Section 27.12.14, “Performance Schema System Variable Tables” . • Database Collation • collation_connection • character_set_client • Definer 13.7.7.41 SHOW VARIABLES Statement SHOW [GLOBAL | SESSION] VARIABLES [LIKE ’ pattern ’ | WHERE  expr ]