Question

How to enable LOCAL capability in MySQL Workbench?

Posted May 23, 2020 12.4k views
MySQLDatabases

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.

×
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

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://)