show variables mysql code example

Example 1: mysql show variables

SHOW VARIABLES;								-- complete list
SHOW VARIABLES LIKE 'secure_file_priv';		-- search
SHOW VARIABLES LIKE 'secure_%';

Example 2: show global variables

Press CTRL+C to copy SHOW [GLOBAL | SESSION] VARIABLES
    [LIKE 'pattern' | WHERE expr]