title: Log all MySQL transactions on a per user basis
body: <p>I have a PHP application that uses a single database for multiple users.  User log on, their ID is stored in a session, and they use the application to retrieve or update data in the database.</p>
  
  <p>For security/archival purposes, I would like to log every SQL transaction on a per user basis.  Note that "user" is not a MySQL user as their is only uses one user.  How do I do this?</p>
  
  <p>I am currently operating Centos 5.8, PHP 5.3.18, and MySQL 5.5.</p>
  
  <p>Thanks</p>