Error：Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot

操作系统Windows10.0；

Mysql版本：8.0

平台：Workbench

Error产生原因在导入导出查询结果到本地的过程中：

SELECT * FROM ashares.matchedtable into outfile 'D:\*******\shipan.csv' character set gbk
fields terminated by ',' optionally enclosed by '"' 
lines terminated by '\n';

出现结果是Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement。

查询相关博客后发现是因为--secure-file-priv 选项设置有限制造成的，但是很多给的方法都是基于5.7版本，8.0一开始没找到配置文件在哪，然后在mysql命令行界面查询：

SHOW VARIABLES LIKE "secure_file_priv";

结果显示为

+------------------+------------------------------------------------+
| Variable_name    | Value                                          |
+------------------+-------------------------