GRANT DELETE ON database.table TO username@'%';

I have given a user full control over one table in a database. Hoever it appears they cant delete records.

I've tried as a privilaged user:

GRANT DELETE ON databasename.tablename TO username@'%';
flush privileges;

But delete stil doesn't work

ERROR 1142 (42000): DELETE command denied to user 'username'@'localhost' for table 'tablename'

Any ideas?

Cheers,

Nathan.