错误:ERROR 1148: The used command is not allowed with this MySQL version
原因:load data local可被利用为高危漏洞,所以8以上mysql默认关闭改功能
解决:修改全局变量启用load data
set global local_infile = 1;
修改config启用load data local
loose-local-infile = 1
错误:ERROR 1148: The used command is not allowed with this MySQL version
原因:load data local可被利用为高危漏洞,所以8以上mysql默认关闭改功能
解决:修改全局变量启用load data
set global local_infile = 1;
修改config启用load data local
loose-local-infile = 1