Anyone got an idea what to enable to make the LOAD DATA INFILE working? I have the global variable 'local_infile' set to ON, the database is answering queries just normaly, but LOAD DATA INFILE results in the error:

Access denied for user 'xyxyxyx'@'%' (using password: YES)

  • I swear I went through at least 50 similar sites. The answer may also be that I just don't have enough rights to do LOAD DATA INFILE. But before I ask DB admin, I want to check whether the fault is on my side. – Jaro Apr 6 '15 at 16:20
  • You may also need the LOCAL keyword: LOAD DATA LOCAL INFILE .... And check for permissions to access the directory where the file is. – Rick James Apr 6 '15 at 17:24

Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege.

-MySQL Manual for LOAD DATA

For generic connection error troubleshooting, go to the corresponding manual page.

| improve this answer | |
  • jynus, you might have also mentioned google.com as a reource to look for answers :-) – Jaro Apr 6 '15 at 16:15
  • I just checked, my username has all privileges granted. Regarding the bad search skills, I think it would be nice to have some patience with newbies... – Jaro Apr 6 '15 at 16:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.