title: "Load data local infile" command not allowed
body: <p>I am using the PHP mysqli library. Every time I try to run a <code>LOAD DATA LOCAL INFILE</code> command, mysqli complains with the message</p>
  
  <blockquote>
    <p>The used command is not allowed with this MySQL version</p>
  </blockquote>
  
  <p>I do not have the same problem with running the command from a MySQL terminal (must login with --local-infile=1 to make it work) or PHPMyAdmin.  Just my PHP+mysqli code experiences this error.</p>
  
  <p>I tried setting this option:</p>
  
  <pre><code>mysqli_options($cnx, MYSQLI_OPT_LOCAL_INFILE, 1);
  </code></pre>
  
  <p>prior to my load data call, but still no-effect.</p>
  
  <p>How do I correct this problem?</p>