title: How to change secure-file-priv option in MySQL on Ubuntu 20.04
body: <p>I am trying to use OUTFILE on Ubuntu 20.04 and getting this error:
  MySQL server version: 8.0.21</p>
  <p>Code:</p>
  <pre><code>mysql&gt; select * into OUTFILE '/home/yash/Desktop/data2.txt' from ticket;
  
  ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
  </code></pre>
  <p>I tried many solutions but it didn't work on Ubuntu 20.04</p>
  <p>If anyone can give a solution for Ubuntu 20.04 and MySQL 8.0.21 then it will be appreciated.</p>