access denied for load data infile in MySQL

mysql load-data-infile mysql-error-1045
Brian picture Brian · Feb 8, 2010 · Viewed 95.6k times · Source

I use MySQL queries all the time in PHP, but when I try 

LOAD DATA INFILE

I get the following error

#1045 - Access denied for user 'user'@'localhost' (using password: YES)

Does anyone know what this means?

Answer

jeremysawesome picture jeremysawesome · Nov 12, 2010

I just ran into this issue as well. I had to add LOCAL to my SQL statement.

For example, this gives the permission problem: 

LOAD DATA INFILE '{$file}' INTO TABLE {$table}

Add LOCAL to your statement and the permissions issue should go away. Like so: 

LOAD DATA LOCAL INFILE '{$file}' INTO TABLE {$table}

Related questions

Why do I get an error when using LOAD DATA INFILE?

I'm trying to use SQL to upload a csv file from my laptop to a database, however I get a strange error. The code I am typing into the SQL window in phpMyAdmin is as follows: LOAD DATA INFILE '/…

Read More
LOAD DATA INFILE within PHPmyadmin

I'm running the following command within PHPmyadmin: LOAD DATA INFILE '/test3.csv' INTO TABLE temp_car FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES (recloc,divdept) AND LOAD DATA INFILE '/…

Read More
How do I import CSV file into a MySQL table?

I have an unnormalized events-diary CSV from a client that I'm trying to load into a MySQL table so that I can refactor into a sane format. I created a table called 'CSVImport' that has one field for every column …

Read More