Admin: 5 revisions imported

2016-04-06T20:03:26Z

5 revisions imported

New page

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 -

<strike>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 </strike>(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)<strike>:
</strike>

<strike>dev-db/mysql innodb
</strike>

<strike>and re-emerge MySQL
</strike>

<strike>emerge -av mysql
</strike>
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:
#skip-innodb
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.
# /usr/bin/mysql_install_db

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.

# /usr/bin/mysql_secure_installation

=== 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');

ConfigureMysqlOnGentoo - Revision history

Admin: 5 revisions imported