- 和其他解决方案一样,查看’local_infile’
show global variables like 'local_infile';
结果如下,如果是OFF,需要设置为ON
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set (0.00 sec)
设置local_infile为ON
set global local_infile = 'ON';
- 如果用java导入,需要在数据库连接加一个参数
&allowLoadLocalInfile=true