0

When trying to import a .csv file to my database I'm receiving the below error message:

ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides

The attempted fix

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile'; mysql> SET GLOBAL local_infile = 1; mysql> SET GLOBAL local_infile = true;

Confirmed that the value stated "On". However I got the same message when I attempted to reload the .csv file.

I am rather new to MySQL. Any help with this would be greatly appreciated.

hangejj
  • 97
  • 3

0 Answers0