ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot exec

SHOW GLOBAL VARIABLES LIKE '%secure%';

查看secure_file_priv 如果是“”则所有目录都可以使用，详细说明：

官网解释：

Command-Line Format--secure-file-priv=dir_nameSystem VariableNamesecure_file_privVariable ScopeGlobalDynamic VariableNoPermitted Values (<= 5.7.5)TypestringDefaultemptyValid ValuesemptydirnamePermitted Values (>= 5.7.6)TypestringDefaultplatform specificValid ValuesemptydirnameNULL

This option sets the secure_file_priv system variable, which is used to limit the effect of data import and export operations, such as those performed by theLOAD DATA and SELECT ... INTO OUTFILE statements and the LOAD_FILE() function. For more information, see the description ofsecure_file_priv.