bdunning
1-28-06, 12:13 AM
I am trying to run a LOAD DATA INFILE via phpMyAdmin's SQL tab. I have uploaded a CSV containing my data to a folder. I have set the permissions on the data file and its enclosing folder to 777 (also tried 766 and 755). I have also tried several different data files. No matter what I do, I get:
#1045 - Access denied for user 'username'@'%' (using password: YES)
I used to run this same command quite frequently and have never had a problem until now. My command looks like this:
load data infile '/www/u/username/htdocs/temp2/gz1.csv'
into table tablename
fields terminated by ','
enclosed by '"'
lines terminated by '\r'
Can anyone suggest a solution? Thanks...
#1045 - Access denied for user 'username'@'%' (using password: YES)
I used to run this same command quite frequently and have never had a problem until now. My command looks like this:
load data infile '/www/u/username/htdocs/temp2/gz1.csv'
into table tablename
fields terminated by ','
enclosed by '"'
lines terminated by '\r'
Can anyone suggest a solution? Thanks...