How to enable LOCAL capability in MySQL Workbench?

Posted May 23, 2020 12.4k views

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.

    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 ( 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.

Submit an Answer
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


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

SET GLOBAL local_infile = true;

for more info refer