Not able to import csv file data to memSQL database table


#1

LOAD DATA INFILE ‘Test1.tsv’ INTO TABLE POC_MEMSQL.TEST1
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’

OR

LOAD DATA INFILE ‘C:\AWORKING\CSV\Test1.tsv’ INTO TABLE POC_MEMSQL.TEST1
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’

Reason:
SQL Error [1142] [42000]: (conn:960218) FILE READ command denied to user ‘ABC’@’%’ for table ‘TEST1’

Please help me in this regards.


#2

Hi,

Can you verify that the ‘ABC’ user has the grants that you expect? You can run the following command to check:

SHOW GRANTS FOR ABC@'%';

That error is specifically referring to the ‘FILE READ’ privilege. You can grant that privilege to the user using the following command:

GRANT FILE READ ON *.* TO ABC@'%';