MySQL

Prerequisites

To connect your DataPostie instance to MySQL, you first need:

• A MySQL host to which the DataPostie instance has whitelisted access.
• A MySQL user with full SELECT privileges on the MySQL databases that contain the data you wish to make available to consumers.
• The password associated with this MySQL user.

Create your MySQL Connection

Enter the following details:

• Specify a connection name
• Select MySQL as your connection dialect
• Under Host, enter the your full MySQL host and port (usually 3306)
• Under Username, enter the MySQL username
• Under Password, enter the MySQL username's password

Test your MySQL Connection

After your MySQL connection is created, click the Test button next to it to ensure it is set up correctly. You can always edit it if need be.