Thanks to this post as a starting point, I managed to connect my Access 2007 app directly to a back end MYSQL in the cloud via a secure SSL connection (not on top of SSH tunnel).
Here's the basics
Step 1: Generate and Enable SSL certs on the backend mysql server
See Reference here...