AW: Troubles creating MySQL rt2 database user on FreeB SD

Getting all the modules was more difficult :wink:

Nope, that was the easy part :slight_smile:

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-