mysql grant problem

[Tomoki Taniguchi]

i have a feisty server that i have installed apache2, php5 and mysql-server.
I am following the instuctions
https://help.ubuntu.com/community/Drupal
to create a new database and grant privileges to a new mysql user.

but i can't get the grant statement to work properly

the grant statement i am using is this

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
CREATE TEMPORARY TABLES, LOCK TABLES ON zendtest.* TO
'zendtest'@'localhost' IDENTIFIED BY 'zendtest';

when i enter it i get
Query OK, 0 rows affected (0.00 sec)
in return.

the statement created a new user but all the privileges are set to N.

i cant get the grant statement to work as it should

what am i doing wrong?

-TIA,
Tomoki