title: MySQL 's 'secure-file-priv' not allowing load data infile, even from the allocated safe folder
body: <p>I am trying to upload a large .csv file into a database (not on a server, just on my local computer only for my use) on MySQL.  I have been having the <strong>Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement</strong> error thrown.</p>
  
  <p>I put my .csv file into the specified 'safe' folder (C:/ProgramData/MySQL/MySQL Server 5.7/Uploads) specified in the 'my' file, but it kept giving me the same error.  Every solution I've seen has been using that folder destination and since that doesn't work can anyone help me get around or turn off the secure-file-priv option?</p>
  
  <p>Here is my code in case wanted:</p>
  
  <pre><code>LOAD DATA INFILE 'C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\my-file.csv'
  INTO TABLE my-table
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  IGNORE 1 ROWS;
  </code></pre>
  
  <p>Thank you for any help</p>