title: How can I have MySQL write outfiles as a different user?
body: <p>I'm working with a MySQL query that writes into an outfile.  I run this query once every day or two and so I want to be able to remove the outfile without having to resort to su or sudo.  The only way I can think of making that happen is to have the outfile written as owned by someone other than the mysql user.  Is this possible?</p>
  
  <p>Edit: I am not redirecting output to a file, I am using the INTO OUTFILE part of a select query to output to a file.</p>
  
  <p>If it helps:<pre>
  mysql --version
  mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2
  </pre></p>