[dev] Setting up hordemgr user in mysql

[Brent J. Nordquist]

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