Mysql导出数据报错1290——解决方案

ERROR 1290: The MySQL server is running with the --secure-file-priv

解决方案：

1、show variables like '%secure%';命令显示文件目录

2、将导入文件放在 /var/lib/mysql-files/文件夹下设置如下：

secure_file_priv='/var/lib/mysql-files/' 或注释掉

3、service mysqld restart
4、导出文件:select distinct(dt) from wo_menhu_h5 order by dt INTO OUTFILE '/var/lib/mysql-files/ccc.txt';