MySQL: Enable LOAD DATA LOCAL INFILE

by

From the MySQL 5.5 manual page:

LOCAL works only if your server and your client both have been
configured to permit it. For example, if mysqld was started with
–local-infile=0, LOCAL does not work. See Section 6.1.6, “Security Issues with LOAD DATA LOCAL”.

You should set the option:

local-infile=1

into your [mysql] entry of my.cnf file or call mysql client with the –local-infile option:

mysql --local-infile -uroot -pyourpwd yourdbname

You have to be sure that the same parameter is defined into your [mysqld] section too to enable the “local infile” feature server side.

It’s a security restriction.

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. How to create a MySQL hierarchical recursive query?
  3. What is the error “Every derived table must have its own alias” in MySQL?
  4. MySQL Error 1215: Cannot add foreign key constraint
  5. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  6. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  9. Mysql: Select all data between two dates
  10. mysql two column primary key with auto-increment
  11. Are you allowed to use numbers as table names in MySQL?
  12. How to reset mysql root password?
  13. MySQL error code: 1175 during UPDATE in MySQL Workbench
  14. Can a table field contain a hyphen?
  15. Select mysql query between date?
  16. MySQL COUNT DISTINCT
  17. How to take backup of a single table in a MySQL database?
  18. MySQL maximum memory usage
  19. MySQL JOIN the most recent row only?
  20. What does SQL clause “GROUP BY 1” mean?
  21. Bogus foreign key constraint fail
  22. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  23. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  24. Syntax error when using except in a query
  25. Easiest way to copy a table from one database to another?
  26. Using index, using temporary, using filesort – how to fix this?
  27. sql like operator on integer
  28. How to make a primary key start from 1000?
  29. MySQL – SELECT * INTO OUTFILE LOCAL ?
  30. The best way to remove value from SET field?

Leave a Comment