EmergencyEMERGENCY? Get 24/7 Help Now!

Extending the secure-file-priv server option

Percona Server has extended secure-file-priv server option. When used with no argument, the LOAD_FILE() function will always return NULL. The LOAD DATA INFILE and SELECT INTO OUTFILE statements will fail with the following error: “The MySQL server is running with the –secure-file-priv option so it cannot execute this statement”. LOAD DATA LOCAL INFILE is not affected by the –secure-file-priv option and will still work when it’s used without an argument.

Version Specific Information

System Variables

variable secure-file-priv
Command Line:No
Config File:Yes
Scope:Global
Dynamic:No
Variable Type:String
Default Value:NULL


General Inquiries

For general inquiries, please send us your question and someone will contact you.