Unable to Load Data from .csv file to mysql table


#1

Hello All,

While importing data from .csv file into a mysql table, I am getting the following error:

This is my command:

mysql> LOAD DATA INFILE ‘/home/pratik58892973/movie_Dataset/links.csv’
-> into table pk_movies_links
-> lines terminated by ‘\n’
-> ignore 1 rows;

ERROR 1045 (28000): Access denied for user ‘sqoopuser’@’%’ (using password: YES)

Please let me know what will be the solution for this.
Thanks in advance.


#2

I forgot to mention the keyword LOCAL as in
LOAD DATA LOCAL INFILE
as the file is on local path