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
Variable Type:String
Default Value:NULL

Table Of Contents

Previous topic

Utility user

Next topic

Expanded Program Option Modifiers