I’m trying to use LOAD DATA with the below command to import CSV files into a managed DO droplet via MySQL Workbench because the Workbench wizard is incredibly slow.

LOAD DATA
    LOCAL INFILE 'C:\...Path...\May22 P2B.csv'
    INTO TABLE May22B.tbl_packages2buy

Running the above gets me ‘error 3948 loading local data is disabled’. So how can I enable loading local data you ask? I found this answer (https://stackoverflow.com/questions/59993844/error-loading-local-data-is-disabled-this-must-be-enabled-on-both-the-client) with a possible solution. But I’ve tried running SET GLOBAL local_infile=1 and I just get error code 1227. access denied you need (at least one of) the super privilege(s) for this operation.

So how can I get loading local data enabled, so I can use LOAD DATA and load my CSV into Workbench/my Database? or is there another fast way to access my database?

Any suggestions would be much appreciated!

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Try setting it from MySQL command line
to check local_infile is set or not
login to MySQL using username and password
and try the following command

SHOW GLOBAL VARIABLES LIKE 'local_infile';

if the local_infile value if false set it to true by using the following

SET GLOBAL local_infile = true;

for more info refer
[https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
](http://)
[https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
](http://)

Submit an Answer