mysql grant problem

[Njoku, George O.]

Try install phpmyadmin.
It makes all the mysql management very easy.

Cheers
George


-----Original Message-----
From: ubuntu-users-bounces at lists.ubuntu.com
[mailto:ubuntu-users-bounces at lists.ubuntu.com] On Behalf Of Tomoki
Taniguchi
Sent: Thursday, September 27, 2007 1:30 PM
To: ubuntu-users
Subject: mysql grant problem

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

-- 
ubuntu-users mailing list
ubuntu-users at lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-users