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、找到