Error Code 1045

[Kevin M]

I am running the follwing SQL script. Table vendor_update gets created and then I get the following Error 1045 message.

"15:20:00 LOAD DATA INFILE 'C:/Users/KPC/Desktop/SOURCE-DATA.csv' INTO TABLE vendor_update FIELDS TERMINATED BY ',' IGNORE 1 ROWS Error Code: 1045. Access denied for user 'car2'@'1.1.1.1' (using password: YES) 0.031 sec"

"car2" is my master user name for all databases. What am I doing wrong? What should I do to fix it?


use car2_Test;

CREATE TABLE vendor_update (
id INT NOT NULL AUTO_INCREMENT,
vendor_model VARCHAR(255) NOT NULL,
vendor_qty float,
PRIMARY KEY (id)
);

LOAD DATA INFILE 'C:/Users/KPC/Desktop/SOURCE-DATA.csv'
INTO TABLE vendor_update
FIELDS TERMINATED BY ','
IGNORE 1 ROWS;