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.


#3

Hi Sandeep, i too facing same issue . I am able to enter into mysql, and created a table but facing access denied error when i am trying to load data from a csv file to mysql table. please help :(. thank you.