title: unable to grant LOCK TABLES permission to user
body: <p>I'm running MySQL 5.1.73-0ubuntu0.10.04.1-log and I'm trying to make it so a user can LOCK TABLES. I GRANTed LOCK TABLEs with the following:</p>
  
  <ul>
  <li><code>GRANT SELECT, LOCK TABLES ON *.* TO 'dbuser';</code></li>
  </ul>
  
  <p>That responds with <code>Query OK, 0 rows affected (0.00 sec)</code>.</p>
  
  <p>After that, when I login as <code>dbuser</code>, and try to do <code>LOCK TABLES table_name WRITE;</code> I get the following error:</p>
  
  <pre><code>ERROR 1044 (42000): Access denied for user 'dbuser'@'localhost' to database 'dbname'
  </code></pre>
  
  <p>I do <code>SHOW GRANTS</code> as dbuser and do not see any GRANT for LOCK TABLES.</p>
  
  <p>Any ideas?</p>