MYSQL报错The MySQL server is running with the --secure-file-priv option so it cannot execute this sta

MYSQL报错The MySQL server is running with the --secure-file-priv option so it cannot execute this sta

show variables like ‘%secure%’;查看 secure-file-priv 当前的值是什么

默认是NULL就代表禁止导出，所以需要设置一下

mysql安装路径下的my.ini文件，设置一下路径：

重新启动mysql服务

net stop mysql

net start mysql

## 导入导出文件
load data infile 'd:/data.txt' into table s(course,stu_name,score);
select * from stu_score into outfile 'd:/a.txt';