title: How to deal with The MySQL server is running with the --secure-file-priv option so it cannot execute this statement on a Mac
body: <p>I'm looking to turn off secure-file-priv on mySQL 5.7.17. I've tried other suggestions for adding secure-file-priv="" to my.cmf, however mySQL refuses to start up afterwards:</p>
  
  <pre><code>bash-3.2# mysql
  mysql: [ERROR] unknown variable 'secure-file-priv='
  bash-3.2# 
  </code></pre>
  
  <p>Other posts suggested secure_file_priv in stead but I get the same response from mySQL: unknown variable. </p>
  
  <p>I've also tried adding <code>--secure-file-priv=/path/to/folder</code> to mySQL's launch daemon, but I get the same error. </p>
  
  <p>Does anyone know how to turn this cumbersome feature off on the Mac version of mySQL?</p>
  
  <p>Thank you!</p>