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:

dev-db/mysql innodb

and re-emerge MySql

emerge -av mysql

Add the MySQL server to the default run-level, so that it will load everytime your server boots.

rc-update add mysql default

Start the MySQL server.

/etc/init.d/mysql start

Set the root password for MySQL.

mysqladmin -u root password 'p4ssw0rd'

If you have already set it and you want to change it

mysqladmin -p -u root password 'n3wp4ssw0rd'

Enter your old password when it prompts you.

You should probably remove .bash_history from your home folder, because your new password will be stored there in clear text.

Creating the *rt3* database

RT comes with a script that creates the initial rt3 database.

rt-setup-database --action init --dba root --prompt-for-dba-password

Adding a user for RT to work through

(Our guide uses my_rt_user; it is recommend that you choose your own name.)

As root, login to MySQL

mysql -p

Grant access rights to my_rt_user.

GRANT ALL PRIVILEGES ON rt3.* TO 'my_rt_user'@'localhost' IDENTIFIED BY 'p4ssw0rd';
FLUSH PRIVILEGES;
QUIT

If you want to change my_rt_user's password, execute the following at the MySQL prompt.

SET PASSWORD FOR 'my_rt_user'@'localhost' = PASSWORD('n3wp4ssw0rd');