MySQL

1. Download and install MySQL Database (http://dev.mysql.com/downloads/mysql/)

2. Create a new database and a user capable of accessing this database with privileges for creating tables included (see MySQL documentation if you have questions about how to administrate databases and users).

3. Download the MySQL JDBC driver (http://dev.mysql.com/downloads/connector/j/) and place it in the classpath for your application server

3a. If you are starting from the Heat Clinic, replace the HSQL driver in the pom.xml with the MySQL driver.

Replace:

<dependency>
    <groupId>org.hsqldb</groupId>
    <artifactId>hsqldb</artifactId>
    <version>2.3.1</version>
    <type>jar</type>
    <scope>compile</scope>
</dependency>

With this:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.32</version>
</dependency>

1. Follow the instructions for your application server for creating a JNDI resource(s). Note that the driver does not go inside the war file(s). Rather it must go on the class path of the server.

2. Update the runtime properties to use the correct dialect for the MySQL. (see Database Configuration).

   blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
   blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
   blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
   

You may also want to check out the more detailed Switch To MySQL Tutorial

At a minimum, we also recommend using the following settings for proper UTF-8 configuration for MySQL in my.cnf:

[mysqld]
lower_case_table_names=1
character-set-server=utf8
collation-server=utf8_general_ci