docker mysql导出表数据xls csv

1、登录到docker的mysql上,输入脚本 SELECT * FROM VehicleDataAndLocation INTO OUTFILE '/etc/mysql/VehicleDataAndLocation.xls'; 2、遇到错误 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 3、没有权限所致。查看安全策略 show variables like '%secure%'; 4、找到