mysql workbench error 1148 无法加载本地数据的解决方法

1.在workbench中输入 show global variables like ‘local_infile’;

结果应该为:on,该问题与local-infile是否=1无关,是workbench的bug;

show global variables like 'local_infile';

set global local_infile='ON';

2.继续输入show variables like ‘secure_file_priv’;

结果应该为C:\ProgramData\MySQL\MySQL Server 5.7\Uploads 这个文件件;

SHOW VARIABLES LIKE "secure_file_priv";

3.将需要导入的文件放入步骤2的文件中;

4.load data local infile命令去掉local,并加上步骤2的文件夹路径,举例如下:

load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/123.csv' ignore into table tablename FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;