Enable local_infile settings

Help
1

My MemSQL cluster is spinned up in Vagrant. I am trying to ingest data from a local file through memsql client, but I not able to ingest data by using LOAD DATA LOCAL INFILE and this is the error that I encountered:
ERROR 1148 (42000): LOAD DATA LOCAL is disabled by your client configuration. You can enable it in the mysql client with the --local-infile option. See https://dev.mysql.com/doc/refman/en/load-data-local.html for more information.

I did try to enable local_infile like below:
SET GLOBAL local_infile = ‘ON’;

However, this setting is still not working for me. Any idea on how to enable local infile?

2

Did you try logging in to the memsql (or mysql) command line client this, like the error message seemed to suggest?

memsql -p --local-infile=ON