[Tickets #5861] Setup.php does not create mysql user and DB permissions

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5861
-----------------------------------------------------------------------
 Ticket             | 5861
 Created By         | lfbm.andamentos at gmail.com
 Summary            | Setup.php does not create mysql user and DB permissions
 Queue              | Horde Groupware Webmail Edition
 Version            | 1.0.3
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


lfbm.andamentos at gmail.com (2007-11-04 09:51) wrote:

$Horde: groupware/scripts/setup.php,v 1.12 2007/06/27 16:25:29 jan Exp $

The script does not create the horde user in MySQL and does not define
horde DB permissions.

I think this is the missing part:

"USE mysql;

REPLACE INTO user (host, user, password)
    VALUES (
        'localhost',
        'horde',
-- IMPORTANT: Change this password!
        PASSWORD('horde')
);

REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
                 delete_priv, create_priv, drop_priv, index_priv)
    VALUES (
        'localhost',
        'horde',
        'horde',
        'Y', 'Y', 'Y', 'Y',
        'Y', 'Y', 'Y'
);

-- Make sure that priviliges are reloaded.
FLUSH PRIVILEGES;"