mysql load data infile secure-file-priv code example
Example 1: mysql show variables like secure_file_priv
SHOW VARIABLES; -- complete list
SHOW VARIABLES LIKE 'secure_file_priv'; -- search
SHOW VARIABLES LIKE 'secure_%';
Example 2: show secure-file-priv in mysql by query
SHOW VARIABLES LIKE "secure_file_priv";