mysql show variables 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]