[rt-users] mysql user 'rt_user'@'localhost' privileges at appropriate level?

Benji Wakely benji.wakely at gmail.com
Mon Jan 31 22:53:46 EST 2005

Hi all.

I had to recreate the user rt_user at localhost in mysql.

Originally I couldn't get access to the web interface at all
("internal server error"),
I ended up recreating the rt_user at localhost account in mysql, 
and granted all privs on the 'rt3' database.

This led to the web interface spitting back debugging messages
( example from error.log:
DBD::mysql::st execute failed: select command denied to user:
'rt_user at localhost' for table 'Users' at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 410.
RT::Handle=HASH(0x8c63c10) couldn't execute the query 'SELECT  * FROM
Users WHERE Name = ?' at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 417.

...I ended up doing 
GRANT ALL PRIVILEGES ON *.* to 'rt_user'@'localhost';
which definitely seems to have fixed things.... :/

What privs are necessary for this user?
I have granted 'all' on the rt3 database, which is fine, 
but what's the most restrictive privs I can set up for the rest of the
mysql installation?

Thanks in advance,

--Benji Wakely

More information about the rt-users mailing list