[dev] Re: [cvs] commit: hermes/scripts/drivers hermes.sql jonah/scripts/drivers jonah_news.sql jonah_weather.sql horde/scripts/db auth.sql category.sql links.sql log.sql prefs.sql sessionhandler.sql token.sql vfs.sql turba/scripts/drivers turba.sql ...

Marko Djukic marko at oblo.com
Mon Jul 14 11:12:39 PDT 2003


Quoting Marko Djukic <tech at oblo.com>:

> mdjukic     2003/07/14 09:33:13 PDT
>
>   Log:
>   get rid of user at localhost construct which breaks some SQLs

anyone have any thoughts on any quick-fixes to this?

if a user is added to the mysql user table as in the scripts:
REPLACE INTO user (host, user, password)
    VALUES (
        'localhost',
        'horde',
        PASSWORD('horde')
    );
then subsequent GRANT statements are run such as without the mysql
horde at localhost syntax:
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_categories TO horde;

the mysql user table ends up, with the second line added by the GRANT statement:
Host       User     Password
localhost  horde    31e43e9079b4ad01
%          horde     <empty>

not exactly sure what the implications are of the second line, but they create a
lot of "noise" in big mysql user tables. and fixing up each script beforehand
is also very tedious.

one solution could be to have the initial user creation script not say
"localhost" but any host as the host:
REPLACE INTO user (host, user, password)
    VALUES (
        '%',
        'horde',
        PASSWORD('horde')
    );

thoughts?

marko


More information about the dev mailing list