title: How should I resolve --secure-file-priv in MySQL?
body: <p>I am learning MySQL and tried using a <code>LOAD DATA</code> clause. When I used it as below:</p>
  
  <pre><code>LOAD DATA INFILE "text.txt" INTO table mytable;
  </code></pre>
  
  <p>I got the following error:</p>
  
  <blockquote>
    <p>The MySQL server is running with the --secure-file-priv option so it cannot execute this statement</p>
  </blockquote>
  
  <p>How do I tackle this error?</p>
  
  <p>I have checked <a href="https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option">another question on the same error message</a>, but still can’t find a solution.</p>
  
  <p>I am using MySQL 5.6</p>