mysql grant problem

[Scott Lockwood]

Does the user have grant priv's?

On Fri, 2007-09-28 at 02:29 +0900, Tomoki Taniguchi wrote:
> 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
> 
-- 
Regards,
Scott Lockwood