How to use MySQL in Liquid Data Mapper

In order to use MySQL in Liquid Data Mapper, you have two choices:

Option 1: Use the MySQL Connector Data Provider - MySQLConnector (Recommended)
This is a 3rd party data provider and is included in the Liquid Studio installation.
To use this option, simply select the MySQL Connector for .NET as your Data Source (see below).
For more information, including the advantages over using the official Oracle MySQL Data Provider, please see:
https://github.com/mysql-net/MySqlConnector/blob/master/README.md

Option 2: Use the Official Oracle MySQL Connector/NET Data Provider - MySQLClient
To use this option, please download the MySQL Connector from the MySQL web site:
https://dev.mysql.com/downloads/connector/net/
This will download a file "mysql-connector-net-9.5.0.msi" which you will need to run to install the data provider on your PC.
Once installed, you will need to copy the contents the folder:

C:\Program Files (x86)\MySQL\MySQL Connector NET 9.5

Into the folder:

C:\Program Files\Liquid Technologies\Liquid Studio\DatabaseProviders\MySql

Note: The examples above are the default installation folders, and will depend on where you chose to Install the products.

You will then be able to add Database Connections for MySQL using the Database->Connect menu:

This will show the Connection Properties dialog. Click "Change,,,"

This will display the Change Data Source dialog, where you can then select the MySQL Data Source:

If you are using Option 1, you will just see the "MySQL Connector .NET" option. If you are using option 2, you will also see the ".NET Framework Data Provider for MySQL" option.

Click "OK" and the Connection Properties will change to enable you to select a MySQL database:

After you select a Database and click "OK", the new MySQL entry will appear in the Database Explorer (View->Database Explorer Ctrl+Alt+D), and will also be available in the Data Mapper Wizard when you select Database Source or Database Target: