AW: [rt-users] Troubles creating MySQL rt2 database user on FreeB SD

[Panizzon Benoit]

>Getting all the modules was more difficult ;-)

Nope, that was the easy part :-)

Finaly I just concluded that the GRANT command of mysql works differently on
FreeBSD and altered etc/acl.mysql that way:

DELETE FROM user WHERE user like '!!DB_RT_USER!!';
DELETE FROM db where db LIKE '!!DB_DATABASE!!';
INSERT INTO user VALUES
('!!DB_RT_HOST!!','!!DB_RT_USER!!',password('!!DB_RT_PASS!!'),'y','y','y','y
','y','y','y','y','y','y');
FLUSH PRIVILEGES;

and removed
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON !!DB_DATABASE!!.* TO
!!DB_RT_USER!!@!!DB_RT_HOST!! IDENTIFIED BY '!!DB_RT_PASS!!';

That way the installation finaly worked.

-Benoit-