mysql grant problem

[Tomoki Taniguchi]

OK figured it out.
I was looking at the wrong table for the privileges.
I was looking at mysql.user table and seeing all privileges set to "N".

but since my grant statement specifies the db,  the privileges
are set up in the mysql.db table.

the privileges were setup properly there.

thank you for all your help


On 9/28/07, Tomoki Taniguchi <tomoki.taniguchi at gmail.com> wrote:
> yes, it is the root account
> connecting to mysql with
> mysql -uroot -p
>
> but still only creates the user with no priv.
>
>
>
>
> On 9/28/07, Scott Lockwood <scott at guppylog.com> wrote:
> > 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
> >
> >
> > --
> > ubuntu-users mailing list
> > ubuntu-users at lists.ubuntu.com
> > Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
> >
>
>
> --
> Tomoki Taniguchi
> SKYPE: taiyocable.com_taniguchi_tomoki
> MSN: tomoki_taniguchi at hotmail.com
> YAHOO: tomoki_taniguchi
> AIM: tomoki taniguchi
>


-- 
Tomoki Taniguchi
SKYPE: taiyocable.com_taniguchi_tomoki
MSN: tomoki_taniguchi at hotmail.com
YAHOO: tomoki_taniguchi
AIM: tomoki taniguchi