title: Need to clear MySQL InnoDB lock without restarting database
body: <p>I have an MySQL InnoDB lock that is preventing a user from logging in. I don't care about the cause of this lock at the moment - I just need to clear the lock without restarting the database. Killing the query process does nothing FYI. Any suggestions? Thanks.</p>