[Tickets #5747] MySQL installation privileges

[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=5747
-----------------------------------------------------------------------
 Ticket             | 5747
 Created By         | todd at magnifisites.com
 Summary            | MySQL installation privileges
 Queue              | Horde Groupware Webmail Edition
 Version            | 1.0.1
 Type               | Bug
 State              | Unconfirmed
 Priority           | 3. High
 Owners             | 
-----------------------------------------------------------------------


todd at magnifisites.com (2007-09-26 12:00) wrote:

I placed a high priority on this ticket merely because of the permissions
involved when using the included sql creation script.  If you feel the
priority is incorrect, please handle accordingly.

Just a quick note to let you know about a very minor inconsistency in the
installation script for MySQL located in 

/scripts/sql/groupware.mysql.sql

At the end of the installation script you likely meant to append the
'@localhost' to the userid during the GRANT statements for tasks and memos,
lines 233 and 252 respectively:

233: GRANT SELECT, INSERT, UPDATE, DELETE ON nag_tasks TO horde;
252: GRANT SELECT, INSERT, UPDATE, DELETE ON mnemo_memos TO horde;

... should likely be ...

233: GRANT SELECT, INSERT, UPDATE, DELETE ON nag_tasks TO
horde at localhost;
252: GRANT SELECT, INSERT, UPDATE, DELETE ON mnemo_memos TO
horde at localhost;

During the installation process, a second (unnecessary) entry is made in
the mysql.user table for the 'horde' user and the permissions in the
mysql.tables_priv table are open for the two tables as well.  One account
('horde'@'localhost') can be used only when connecting from the localhost
whereas the other ('horde'@'%') can be used to connect from any other
host.

Best regards,
Todd