title: how to edit secure_file_priv using MYSQL Docker container
body: <p>I created MySQL cluster of nodes (2 datanodes, 1 management node, and 1 MySQL server node) on Docker Following the instructions from this link:</p>
  
  <p><a href="https://mysqlmed.wordpress.com/2017/09/04/mysql-cluster-in-docker-quick-step-by-step" rel="nofollow noreferrer">https://mysqlmed.wordpress.com/2017/09/04/mysql-cluster-in-docker-quick-step-by-step</a></p>
  
  <p>Then I created a MySQL table to import a csv file (named <code>daily.csv</code>) using the command:</p>
  
  <pre><code>LOAD DATA INFILE 'C:/Users/Utilisateur/Desktop/daily.csv' INTO TABLE daily IGNORE 1 LINES;
  </code></pre>
  
  <p>and I got the 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>When I add <code>LOAD DATA LOCAL INFILE ..</code></p>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>ERROR 2 (HY000): File 'C:/Users/Utilisateur/Desktop/daily.csv' not found (Errcode: 2 - No such file or directory)</p>
  </blockquote>
  
  <p>When i check my <code>secure-file-priv</code> using the command:</p>
  
  <p><code>SELECT @@global.secure_file_priv</code></p>
  
  <p>I get the Following path: <code>/var/lib/mysql-files/</code> but I have no idea how to access to it in order to copy my csv file, or even to access <code>my.ini</code> MySQL config file to change the variable <code>secure-file-priv</code> into <code>NULL</code>, which as I saw is another solution to get permissions to access my file.</p>
  
  <p>As I am using Docker, I have no idea how to access the MySQL container config file.</p>
  
  <p>I tried many ways but I see no issue. Could you please help me with this I would be very delighted as I spent a lot of time trying to fix it??</p>
  
  <p>I followed these instructions but don't know where the file <code>/etc/mysql/my.cnf</code> to change the variable <code>secure_file_priv</code> to <code>NULL</code> is:</p>
  
  <p><a href="https://stackoverflow.com/questions/37543177/mysql-making-secure-file-priv-option-to-null">Mysql making --secure-file-priv option to NULL</a></p>