Hope this helps someone. I used ODBC to MySQL over SSH port fowarding on a Windows client. Here goes:
1) Download and install cygwin (www.cygwin.com) on your windows machine; make sure to include OpenSSH, tcp_wrappers, and zlib. There’s a nice set of instructions here: http://pigtail.net/LRP/printsrv/cygwin-sshd.html. NOTE: You can also use Plink.
2) Download and install MySQL Connector / ODBC 3.51 on your machine, located here: http://dev.mysql.com/downloads/connector/odbc/3.51.html. I downloaded the Windows Zip/Setup.EXE
3) I needed to comment out the line “skip networking” in /etc/my.cnf. I did this by 1) SSH into my server, 2) type cd /etc and press enter, 3) type pico my.cnf and press enter, 4) put a “#” in front of the phrase “skip networking” 5) Save 6) Restart MySQL server.
4) Now you’re ready to set up an SSH tunnel from your local machine to the host. Open Cygwin and use the following command:
ssh -N -f -L 3307:localhost:3306 email@example.com.
5) Setup the ODBC connection. In Vista, goto Control Panel -> Administrative Tools -> Data sources and click Add. Select MySQL ODBC 3.51 Driver, click finish, and fill in the fields like such:
Data source name: You pick!
Description: You pick
User: the name that you use to login to your server
Password: ******** Note: Your password needs to be 8 characters or less.
Database: the name of the database to connect to.
On the 2nd page of the dialog, enter port 3307
Click Test and you should be able to connect!
6) To connect MS Access to your database(s), goto external data -> import from ODBC, and when it says select data source goto machine data source. You should see your data source name. Click on that and follow the prompts. You’re good to go!