In addition to using the embedded HyperSQL database, you can install a MySQL database or use an existing MySQL or Oracle database. The following procedure explains how to install a new MySQL database.

Prerequisites

None

Linux (Red Hat)

1. Download MySQL 5.6 or higher from http://dev.mysql.com/downloads/mysql/. Be sure to select the correct download (for the correct platform). For this guide, we used the Red Hat 6 (64-bit) RPM installer, which was named MySQL-server-5.6.11-2.el6.x86_64.rpm.
2. Log in to the system as root.

3. Install MySQL Server.

rpm –i MySQL-server-5.6.11-2.el6.x86_64.rpm

MySQL should be automatically configured to start when the system starts.

To start MySQL manually:

/etc/init.d/mysql start

To stop MySQL manually:

/etc/init.d/mysql stop

To restart MySQL manually:

/etc/init.d/mysql restart

Windows

1. Download MySQL 5.6 or higher from http://dev.mysql.com/downloads/mysql/
   Be sure to select the correct download (for the correct platform). For this guide, we used the Windows (x86, 32-bit) MSI installer, which was named mysql-installer-community-5.6.11.0.msi.
2. Run the installer as Administrator.
   • If MySQL was installed before: You may need to delete C:\Users\All Users\MySQL.

3. Add the MySQL bin folder to the system PATH. For example:

   set PATH=%PATH%;C:\Program Files\MySQL\MySQL Server 5.6\bin

MySQL will be automatically configured to start when the system starts.

To start MySQL manually, run services.msc and look for the MySQL56 service.