Previous
2.4 Installing MySQL
Daisy requires one of the following MySQL versions:
- version 4.0.20 or higher (we're not making this number up: there have been various bug fixes or improvements between versions 4.0.0 and 4.0.20 on which Daisy depends)
- version 4.1.7 or a newer version from the 4.1.x series
The 4.1 version of MySQL has the big advantage that it supports UTF-8, so if you can choose, pick the 4.1.
MySQL can be downloaded from mysql.com. Install it now, and start it (often done automatically by the install).
Windows users can take the "Windows Essentials" package. During installation and the configuration wizard, you can leave most things to their defaults. In particular, be sure to leave the "Database Usage" to "Multifunctional Database", and leave the TCP/IP Networking enabled (on port 3306). When it asks for the default character set, select "Best Support For Multilangualism" (this will use UTF-8). When it asks for Windows options, check the option "Include Bin Directory In Windows Path".
Linux users: install the "MySQL server" and
"MySQL client" packages. Installing the MySQL server RPM will automatically
initialise and start the MySQL server. To enable UTF-8: after installation,
shutdown MySQL (/etc/init.d/mysql stop), and edit or create the file
/var/lib/mysql/my.cnf, and add the following:
[mysqld]
default-character-set=utf8
[mysql]
default-character-set=utf8
(note: don't do this if you already have data in your mysql database! See the
MySQL documentation)
Afterwards, start the server again by executing /etc/init.d/mysql start
Special configuration if using MySQL version 4.0.x
If you are using MySQL 4.0.x, then a change needs to be made to the configuration of the database server. More specifically, the parameter 'sql_mode' must be set to 'ANSI_QUOTES'. The easiest way to do this is by adding it to the my.cnf file. Therefore, open the my.cnf file in a text editor (on unix typically located at /var/lib/mysql/my.cnf), and in the section [mysqld] add the following line:
sql_mode = ANSI_QUOTES
Restart the MySQL server after making this change.