Cheetah Configure MySql

Owned by Former user (Deleted)
Last updated: Jan 02, 2011 by Michael VorburgerVersion comment

The settings proposed for my.cnf on this page appear to be outdated, and cause issues on developer workstations; they make the testRealSchemaFromCheckpoint in org.mifos.framework.persistence.LatestTestAfterCheckpointIntegrationTest fail when the schema is compared for equality, because there is a "COLLATE utf8_unicode_ci" inserted in many places (and thus the schema comparison fails).

You need to configure mysql to use InnoDb as the default storage engine, and utf8 as the default charset.

Linux and Mac OS X

  • Add the following lines the [mysqld] section of your my.cnf file: 
    default_storage_engine=innodb
default_character_set=utf8
character_set_server=utf8
default_collation=utf8_unicode_ci
skip_character_set_client_handshake
character_set_client=utf8

Windows

  • Use the installer.
  • Select InnoDb as the default storage engine.
  • Select utf8 as the default character set.