secure file priv mysql code example

Example 1: show secure-file-priv in mysql by query

SHOW VARIABLES LIKE "secure_file_priv";

Example 2: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

LOAD DATA LOCAL INFILE ...