MySqlConnector.MySqlException:“Loading local data is disabled

MySqlConnector.MySqlException:“Loading local data is disabled; this must be enabled on both the client and server sides”

执行MySql MySqlBulkLoader批导数据报错。

解决方案

set global local_infile = 1;
SHOW GLOBAL VARIABLES LIKE 'local_infile';

Navcate客户端执行 set global local_infile = 1;

或者：mysql> set global local_infile = 1;

查看结果

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';