How were you manipulating the permissions?
I find that the stock query works fine:
GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'%' ;
GRANT SELECT, INSERT,DELETE on mydb.* to systemuser@'localhost';
although you may want to play around with allowable networks to connect from.
More typic
Today I tried to set few user rights for a user. What I need is-
There a database called 'mydb' Two users for Mysql 5 on Win 2003 server. One
is root and second is 'systemuser'. 'systemuser' do not have right for
anything on Mysql, information_schema, but should have only SELECT, INSERT,
UPDATE an