MySQL Error while loading data


#1

Hi,

I am unable to load a csv file into a MySQL table using LOAD command. Below is the error.

mysql> LOAD DATA INFILE ‘/home/sreenivaskalahasticareer2915/bank.csv’ INTO TABLE bank_marketing FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\r\n’;

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

Please do the needful.

Thanks,
Sreenivas Kalahasti


#2

Please launch the mysql prompt using the command displayed on MyLab. The password of mysql is mentioned over there.