The MySQL database can be downloaded from http://www.mysql.com/downloads/mysql/. 

The default configuration uses a MySQL database with the name tricia locally available under the user account root with a password you have chosen during the installation. In order to create the database you have to connect to MySQL with the command line mysql -u root -p. You will be asked for the password.

After connecting to the MySQL server you can create the required database with the following SQL command:

CREATE DATABASE tricia;

Creating a MySQL user for Tricia

This should be done if there are other databases on the MySQL server:

grant ALL PRIVILEGES on tricia.* to 'tricia'@'<hostname>' identified by '<PASSWORD>'; 
grant SELECT on mysql.columns_priv to 'tricia'@'<hostname>'; 
grant SELECT on mysql.tables_priv 'tricia'@'<hostname>';

GUI tools for database admininstration

For administration of your MySQL database we  recommend you download and use the GUI tools from http://dev.mysql.com/downloads/gui-tools/.

Tweaking the configuration of your MySQL server

Packet size

When importing large databases following error can occur:

MySQL Error Nr.2006-MySQL server has gone away

This can be fixed by increasing the value of the MySQL variable max_allowed_packet (http://bugs.mysql.com/bug.php?id=14236). This is done by inserting the following line in the my.ini file:

[mysqld]

max_allowed_packet=16M

For more information have a look at http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html.

Memory consumption

The main memory consumed by the MySQL database can be increased using the parameter

innodb_buffer_pool_size

On the wwwmatthes installation this value ist set to 500MB. The biggest table there is entitydiff (currently 600MB data / 50MB index)