The URL above assumes a UTF-8 database — i.e. created with create database crowdiddb character set utf8;.

MySQL closes idle connections after 8 hours, so the autoReconnect=true is necessary to tell the driver to reconnect.

Delete the minEvictableIdleTimeMillis, timeBetweenEvictionRunsMillis and maxActive attributes (which are only needed for HSQL, and degrade performance otherwise).

4. Configure CrowdID to use MySQL

Edit the build.properties file (located in the root of the Crowd distribution) and modify the hibernate.dialect to the following.

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

Then run ./build.sh or build.bat. This will configure CrowdID to use the MySQL dialect.

If you do not wish to edit this file and run the build script, you can edit the jdbc.properties (which the above script modifies) directly. The jdbc.properties file is located here: crowd-openidserver-webapp\WEB-INF\classes\jdbc.properties. Modify the file to the following: