access denied for load data infile in MySQL

by

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}

More Related Contents:

  1. Mysql permission errors with ‘load data’
  2. How do I import CSV file into a MySQL table?
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. MySQL load NULL values from CSV data
  6. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  7. brew install mysql on macOS
  8. How can I restore the MySQL root user’s full privileges?
  9. How to import a CSV file into a MySQL table
  10. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  11. How to reset mysql root password?
  12. MySQL – ERROR 1045 – Access denied
  13. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  14. Importing a csv into mysql via command line
  15. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  16. Import CSV to MySQL
  17. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  18. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  19. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  20. MySQL load data infile – acceleration?
  21. 1052: Column ‘id’ in field list is ambiguous
  22. Is the primary key automatically indexed in MySQL?
  23. Cumulative sum over a set of rows in mysql
  24. No connection could be made because the target machine actively refused it (PHP / WAMP)
  25. MySQL SELECT DISTINCT multiple columns
  26. How can I correct MySQL Load Error
  27. Using ALTER to drop a column if it exists in MySQL
  28. Count number of unique values
  29. How to format number with “.” as thousands separator and “,” as decimal separator?
  30. Error installing mysqlclient for python on Ubuntu 18.04

Leave a Comment