Error Code: 2068 while loading csv file into MySql

Question

I am using Amazon RDS MySql for data storage. I am able to load data by specifying the column values, however, when I try to load the data from my local machine to MySql, it fails with Error: 2068.

LOAD DATA LOCAL INFILE '/Users/priya/Documents/Atlas/data/The_Atlas_0820.csv' INTO TABLE schedule 
 FIELDS TERMINATED by ','
 ENCLOSED by '"'
 LINES TERMINATED by '\n' IGNORE 1 LINES (Carrier1, FlightNo1, DupCar1,DupCar2, DupCar3, 
DupCar4,DupCar5, DupCar6,DupCar7, DupCar8,DepAirport, ArrAirport);

Error Code: 2068. LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.

I also checked SHOW GLOBAL VARIABLES LIKE 'local_infile'; and it is set to "ON".

If i use Terminal to open a connection with MySql and execute the command there, it works ok.

$ ./mysql -h <hostname> -P 3306 --local_infile=1 -u <username> -p

But how to make it work in MySql Workbench.

Answer 1

It seems that there is a bug in MySQL Workbench for LOAD DATA LOCAL INFILE, check if the workaround in this link works for you:

MySQL Workbench 8.0 restricts usage of LOAD DATA LOCAL INFILE

or there is another solution that seems to work here:

Workbench 8.0.12 no longer allows LOAD DATA LOCAL INFILE