title: secure-file-priv Empty set
body: <p>Windows 2007
  MySQL 5.7</p>
  
  <p>Receiving error :</p>
  
  <blockquote>
    <p>ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement</p>
  </blockquote>
  
  <p>So I assumed that it was simply a privilege error for the directory that I had stored my DB.</p>
  
  <p>So I ran: </p>
  
  <blockquote>
    <p>SHOW VARIABLES LIKE "secure-file-priv";</p>
  </blockquote>
  
  <p>and returned:</p>
  
  <blockquote>
    <p>Empty set (0.00 sec)</p>
  </blockquote>
  
  <p>so I searched for "my.ini"
  my.ini is located in C:\ProgramData\MySQL\MySQL Server 5.7</p>
  
  <p>MySQL is installed in C:\Program Files (x86)</p>
  
  <p>I made a copy of my Links.csv into the folder location of my.ini and the error still returned.</p>
  
  <p>Script:</p>
  
  <blockquote>
    <p>mysql> LOAD DATA INFILE 'Links.csv' INTO TABLE Links;</p>
  </blockquote>