title: MySQL execute as user or impersonate
body: <p>In MySQL, is there a way to execute a query as a specific user to test table permissions?  Is there a way to impersonate a user execution context when you are connected with a higher privileged account?</p>
  
  <p>In the MSSQL world, one would use EXECUTE AS login = 'username', followed by your SQL Statements, then finally a REVERT, to close the impersonation.</p>
  
  <p>Is there something similar in MySQL?</p>