title: I am trying to export a MySQL table, but I am receiving --secure-file-priv
body: <p>I understand there are a lot of other similar questions, but I have pretty much looked into all the other posts and all of the other suggestions have not worked.</p>
  
  <p>I am currently using a macOS Sierra version 10.12.2</p>
  
  <p>MySQL version 5.7.17</p>
  
  <p>SELECT @@GLOBAL.secure_file_priv; and SHOW VARIABLES LIKE "secure_file_priv"; are showing secure_file_priv = to NULL.</p>
  
  <p>I do not have a my.cnf file on my system (find: my.cnf: No such file or directory)</p>
  
  <p>I have read many posts that mentioned changing the value of secure_file_priv, but I am unable to find it.</p>
  
  <p>The following posts on here I have addressed:</p>
  
  <p><a href="https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option">Solution 1</a></p>
  
  <p><a href="https://stackoverflow.com/questions/34102562/mysql-error-1290-hy000-secure-file-priv-option">Solution 2</a></p>
  
  <p><a href="https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-file-priv-in-mysql">Solution 3</a></p>
  
  <p>I wish this one was answered as it relates to my situation:</p>
  
  <p><a href="https://stackoverflow.com/questions/40528598/error-1290-hy000-the-mysql-server-is-running-with-the-secure-file-priv-opti">Solution 4</a></p>
  
  <p><a href="https://stackoverflow.com/questions/37596163/disable-secure-priv-for-data-loading-on-mysql">Solution 5</a></p>
  
  <p>At the end of the day it looks like changing secure_file_priv is the place to start, I just cannot find it.</p>
  
  <p>I am sure that the OUTFILE location may be incorrect for the above, but that is because I do not know where I have file access because I do not know how to change/locate secure_file_priv.</p>