I have written a Xojo program that connects to a MySQL DB on an external provider. The program does a fairly complex query and I download filtered set of data for either Insert or Update into a local MS-SQL server for analysis. I “rearrange” the data and the local tables do not look like the much more complex source tables. For security reasons the external provider has restricted the connection to their server to the IP address of our server which is Windows.
From time to time I have a need to query the external provider database directly. Because my desktop is on a DHCP connection there was no easy way to provide a restricted IP address that did not change for my desktop computer. Currently I just do a RDP session to the Windows server and run a free client on that machine that is allowed access from it’s fixed IP. This works OK but I would much prefer to use a query tool on my Mac (SequelPro).
The MySQL Router module seems like it might be able to route a connection from my desktop through the server to the external provider MySQL DB.
Does anybody have experience with the MySQL Router module?
For security I think I could probably set up a Windows firewall rule to only allow an inbound connection on a special port from a sub-netted IP address in my DHCP range. Presumably the MySQL Router could translate the port to the standard MySQL port. If not, since MySQL is not running on the Windows box, I could just connect to the router on the standard port with the firewall restrictions for my DHCP range.
Before attempting this I thought maybe I would get a few opinions.
Thanks.