title: What privileges should I grant to my InnoDB MySQL user?
body: <p>I've a MySQL user (InnoDB engine) and I was wondering what would be the safe privileges to grant for it?
  Currently I've granted it permission to access the specific database and these privileges:</p>
  
  <pre><code>SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, CREATE TEMPORARY TABLES
  </code></pre>
  
  <p>But since it's InnoDB I was wondering if I need to explicitly grant LOCK TABLES privilege to this user? Also I'm not sure whether I even need to grant CREATE TEMPORARY TABLES for it.
  Could you help me out here to figure out which privileges should I grant?
  Hibernate will have access to this user so I was also wondering what would be enough for it to work properly?</p>