CODEWITHSUNDEEP
mysqlphpmyadmin
user2779537
user2779537

Reputation: 21

1045 error when using LOAD DATA INFILE

I'm trying to use PHPmyadmin to import a CSV file to a mysql database, however I get a 1045 error. I get the following error:

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

Upvotes: 1

Views: 1889

Answers (2)

Alexandre
Alexandre

Reputation: 134

I know that this is a rather old question but I had the same issue with mySql 5.1.61.

What I tried to do was, from a MySql client, to run the following command:

LOAD DATA INFILE '/myProjectDir/theFile.csv'
INTO TABLE someTable
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

I gathered information from various places, tried several options and figured out that all these points must be checked:

  • the user must have FILE privilege:

    GRANT FILE ON *.* TO 'theUser'@'%' IDENTIFIED BY 'thePassword';

  • the file permissions must be set so that the world can read it (actually it shall be OK if the mysqld process is able to read it):

    chmod o+r theFile.csv

  • the file must be located in the dedicated temporary directory that is defined in the my.cnf config file:

    [mysqld]

    tmpdir=/tmp/mysql

  • every item in the file path must have its permissions set in the same fashion as the file itself

Upvotes: 1

Marc Delisle
Marc Delisle

Reputation: 9012

You need the FILE privilege to use this command.

Upvotes: 0

Related Questions