Table of Contents
1. Install MySQL ODBC Connector.
Download it here: https://dev.mysql.com/downloads/connector/odbc/
2. Run ODBC
Search for ODBC Data Source, select 32 or 64 bit based on your OS. My OS is Windows 10 64bit, so I select 64-bit.
3. Add a new DSN
Click on Add button to add a new DSN
select MySQL ODBC Driver
Enter parmeters to the screen.
In order to complete the PCI compliance requirements the remote MySQL connection to the server's primary IP is blocked. For establishing a remote MySQL connection to a database you have to use the server's secondary IP. The secondly IP is shown on Remote database access hosts screen.
4. Test connection
Click on Test button to verify the connection is working.