[dev] Setting up hordemgr user in mysql

Scott Martin martin@math.ohiou.edu
Wed, 1 Nov 2000 11:25:53 -0500


OK, so the last thing before I write this up in the INSTALL document, do you
want me to dump the "Y"'s for "drop" and "create"?

----- Original Message -----
From: "Brent J. Nordquist" <bjn@horde.org>
To: <dev@lists.horde.org>
Sent: Wednesday, November 01, 2000 10:37 AM
Subject: Re: [dev] Setting up hordemgr user in mysql


> On Wed, 1 Nov 2000, Scott Martin <martin@math.ohiou.edu> wrote:
>
> > So again, could you post the proper commands? Also, Chuck says the "Y"'s
> > below need to be "N"'s. Correct?
>
> The confusion is that there are two tables, user and db, that need to be
> updated.  Chuck means "N"'s in user, because in user they are grants to
> all databases.  Then you put "Y"'s in db, just for the horde database.
>
> >From the 2.2 imp/docs/DATABASE:
>
> REPLACE INTO user ( host, user, password )
>     VALUES (
>         'localhost',
>         'hordemgr',
>         password('hordemgr')
>     );
>
> REPLACE INTO db ( host, db, user, select_priv, insert_priv, update_priv,
>                   delete_priv, create_priv, drop_priv )
>     VALUES (
>         'localhost',
>         'horde',
>         'hordemgr',
>         'Y', 'Y', 'Y', 'Y',
>         'Y', 'Y'
>     );
>
> Hmmm... I'm just looking at that now... you may not want Y for create and
> drop, unless you want hordemgr to be able to drop the tables themselves.
>
> --
> Brent J. Nordquist <bjn@horde.org>
> Yahoo!: Brent_Nordquist / AIM: BrentJNordquist / ICQ: 76158942
>
>
> --
> Horde Developers mailing list: http://horde.org/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: dev-unsubscribe@lists.horde.org
>
>