mysql grant problem

[Tomoki Taniguchi]

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