解决方法MySQL ERROR 3948 (42000): Loading local data is disabled； this must be enabled on both the

MySQL执行LOAD DATA语句时报错

远程执行登录语句，配置local-infile后，执行LOAD DATA
mysql --local-infile=1 -h172.111.111.111 -u root -p123456
远程执行LOAD DATA时报错
ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides

解决方案

查看是否开启加载本地文件 show variables like 'local_infile';

开启全局本地文件设置 set global set local_infile=on;

加载数据成功 load data local infile 'f:/temp/pdm/tmp_ex_md_product_color_rn_split_pt1' into table md_product_color FIELDS TERMINATED BY '^' LINES TERMINATED BY '\r\n' ;