This guide assumes that RT is running on the same machine as the MySQL server.
Setting a root password for !MySQL on Gentoo (for first time installers)
Switch to the root user of your system.
$ su -
If you have not already done so, MySQL must be installed with the "innodb" USE flag. The easiest way to do this is to add it to /etc/portage/package.use (this USE flag is deprecated with current versions of MySQL in portage, so you shouldn't need to re-emerge if your MySQL install is recent) :
dev-db/mysql innodb and re-emerge MySQL
emerge -av mysql
Verify that the skip-innodb is commented out in /etc/mysql/my.cnf. If it is not, then put an octothorpe in front of it:
and restart the mysql server:
# /etc/init.d/mysql restart
Add the MySQL server to the default run-level, so that it will load everytime your server boots.
# rc-update add mysql default
Install the MySQL datase.
Start the MySQL server.
# /etc/init.d/mysql start
Set or change the root password for MySQL and remove the test database and anonymous user.
Creating the RT database
RT comes with a script that creates the initial rt4 database.
# /var/www/myrt/rt-4.0.5/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password
Adding a user for RT to work through
(Our guide uses rt_user; it is recommend that you choose your own name.)
As root, login to MySQL
# mysql -p
Grant access rights to rt_user.
GRANT ALL PRIVILEGES ON rt4.* TO 'rt_user'@'localhost' IDENTIFIED BY 'p4ssw0rd'; FLUSH PRIVILEGES; QUIT
If you want to change rt_user's password, execute the following at the MySQL prompt.
SET PASSWORD FOR 'rt_user'@'localhost' = PASSWORD('n3wp4ssw0rd');