title: Mysql making --secure-file-priv option to NULL
body: <p>I am running MySQL in Ubuntu. I getting this error while running specific set of queries.</p>
  
  <blockquote>
    <p>The MySQL server is running with the --secure-file-priv option so it cannot execute this statement</p>
  </blockquote>
  
  <p>When I did <code>SELECT @@secure_file_priv;</code> in my mysql server I got <code>/var/lib/mysql-files/</code>. I think I need to make this to <code>NULL</code>.</p>
  
  <p>This is the query I am running:</p>
  
  <pre class="lang-sql prettyprint-override"><code>LOAD DATA INFILE :file INTO TABLE test_files
  COLUMNS TERMINATED BY ',' ENCLOSED BY '\"'
  LINES TERMINATED BY '\n';
  </code></pre>
  
  <p>Now the question is how to make this <code>NULL</code>?</p>