MySQL configuration Guide for Windows 
The Worklight Platform requires a connection to a database engine with JDBC support.
Our recommendation to developers is that they download and install MySQL and its official JDBC driver Connector/J.
Both files can be downloaded from the mysql.com website. to expedite the process, we provide the following tips.
In order to download MySQL and its JDBC driver, please follow these steps:
1. MySQL
 
• Download the MySQL database installation from http://www.mysql.com/downloads/mysql/.
• Install the database on your computer, Run the installer and follow the instructions.
• Once installation is complete, the MySQL installer will automatically launch the MySQL Server Instance Configuration wizard. Select the default configuration settings.
  If for some reason, you encounter any installation difficulties or you are using a pre-installed database, please ensure that your database is configured to be transactional, not use strict mode, and use UTF-8 as default encoding, as described in the following presentation.
 
MySQL Configuration Settings - Windows
View more presentations from Worklight.
2. MySQL JDBC Driver Connector/J
 
The Worklight Server accesses the MySQL database via a JDBC driver. The JDBC driver for MySQL is not shipped with the database, but should rather be downloaded separately.
• Download the MySQL JDBC driver Connector/J from http://dev.mysql.com/downloads/connector/j/5.1.html.
• Unzip the package and place its contents (a single .jar file) in a folder of your choice.
• When installing the Worklight Platform, enter the path to this jar file in the “JDBC Connector File” field as depicted below.
 
 
 
 

This page will guide you through the process of installing the WorkLight development environment. The WorkLight development consists of the WorkLight Server and the Eclipse-based WorkLight Studio. The WorkLight Server requires a database for operating, and supports MySQL 5 and Oracle 10g. For development purposes, you must use the MySQL 5 database.