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_name
System Variable	Name	secure_file_priv
	Variable Scope	Global
	Dynamic Variable	No
Permitted Values (<= 5.7.5)	Type	string
	Default	empty
	Valid Values	empty
		dirname
Permitted Values (>= 5.7.6)	Type	string
	Default	platform specific
	Valid Values	empty
		dirname
		NULL

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 the LOAD DATA and SELECT ... INTO OUTFILE statements and the LOAD_FILE() function. For more information, see the description of secure_file_priv.