title: GRANT DELETE ON database.table TO username@'%';
body: <p>I have given a user full control over one table in a database.  Hoever it appears they cant delete records.</p>
  
  <p>I've tried as a privilaged user:</p>
  
  <pre><code>GRANT DELETE ON databasename.tablename TO username@'%';
  flush privileges;
  </code></pre>
  
  <p>But delete stil doesn't work</p>
  
  <pre><code>ERROR 1142 (42000): DELETE command denied to user 'username'@'localhost' for table 'tablename'
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Cheers,</p>
  
  <p>Nathan.</p>