title: MySQL:how to export data from mysql to a txt?
body: <p>i want to export data from mysql to a txt.</p>
  
  <p>i use </p>
  
  <p><i>select * from users2 into outfile 'C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\1.txt'</i></p>
  
  <p>but there is an error:</p>
  
  <p><i>ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement</i></p>
  
  <p>i try to solve with:
  show variables like '%secure%';
  the result is that:</p>
  
  <p>+--------------------------+------------------------------------------------+
  | Variable_name            | Value                                          |
  +--------------------------+------------------------------------------------+
  | require_secure_transport | OFF                                            |
  | secure_auth              | ON                                             |
  | secure_file_priv         | C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\ |
  +--------------------------+------------------------------------------------+</p>
  
  <p>the path is that i use in the above.
  so i don`t know how to solve it.</p>