I am trying to execute the following command:
LOAD DATA INFILE 'ratings.txt' INTO TABLE westernb_western.ratings FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (year, school, groupname, director, class, dist_rating, state_rating);
I keep getting this error:
ERROR 1045: Access denied for user: 'westernb@localhost' (Using password: YES)
I'm pretty sure that the problem is related to WHERE I'm telling it to look for the file, but I have tried multiple things and nothing seems to work.
I've tried the pwd command at the command line. it told me that the file was located here:
home/westernb/public_html
but knowing that has not solved my problem.
help?
LOAD DATA INFILE 'ratings.txt' INTO TABLE westernb_western.ratings FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (year, school, groupname, director, class, dist_rating, state_rating);
I keep getting this error:
ERROR 1045: Access denied for user: 'westernb@localhost' (Using password: YES)
I'm pretty sure that the problem is related to WHERE I'm telling it to look for the file, but I have tried multiple things and nothing seems to work.
I've tried the pwd command at the command line. it told me that the file was located here:
home/westernb/public_html
but knowing that has not solved my problem.
help?