The MySQL server is running with the –secure-file-priv option so it cannot execute this statement

If you get this error after running the command:

LOAD DATA INFILE "path_to_file/file.csv"
INTO TABLE table_name
COLUMNS TERMINATED BY ','


Then just add the keyword LOCAL to the command and it will work:

LOAD DATA LOCAL INFILE "path_to_file/file.csv
INTO TABLE table_name"
COLUMNS TERMINATED BY ','