title: MySQLdump with WINDOWS10 : OS errno 13 - (Permission denied) when executing 'SELECT INTO OUTFILE'
body: <p>I am unable to write tab separated text files into specified TSV/ folder using mysqldump on WINDOWS10 (MySQL80 service). </p>
  
  <ul>
  <li>The Command prompt (or powershell) is in admin mode. </li>
  <li><code>secure-file-priv =""</code> in <code>my.ini</code> MySQL config file. </li>
  <li>MySQL was installed on my local computer and I use a localhost connection with the <code>root</code> username.</li>
  </ul>
  
  <p>Command is:
  <code>mysqldump -T C:\Users\...\20200430_Dump\TSV\ --user root  -p database_name</code></p>
  
  <p>OUTPUT:</p>
  
  <blockquote>
    <p>mysqldump: Got error: 1: Can't create/write to file 'C:\Users...\20200430_Dump\TSV\table_name.txt' (OS errno 13 - Permission denied) when executing 'SELECT INTO OUTFILE'.</p>
  </blockquote>
  
  <p>They are many related post on LINUX but I am <strong>specifically</strong> looking for an solution for <strong>WINDOWS</strong></p>
  
  <p>My small hypothesis:
  Some linux posts suggest that mysqld use a specific user-account (that seems to be <code>mysql</code> in linux but this is unfortunately not documented at all for any OS). So I imagine that when the server is executing <code>INTO OUTFILE</code> queries he needs to have permission for the TSV/ folder, but i do not know how to do give him this permission in WINDOWS. </p>
  
  <p>best</p>