It’s possible, although we don’t have any publicly available documentation to point you to on this one. Let us know if you’re successful in getting this to work.
Basically, on our side, all you need to do is grant permission to the IP or range of IPs you’ll be connecting from, and then configure Access or whatever program properly.
Here’s some directions, modified from our internal documentation on this. I haven’t done this myself (mysqlf?), so I can’t give you a lot more information than this.
You must also install the Mysql drivers so that access can connect to our databases. Just unzip the myodbc file and run setup on your machine.
Now we have to set up the data sources. Go to control panel, open ODBC. You should have opened a window that says “ODBC Data Source Administrator”. Choose System DSN tab. Choose “Add…” Another window pops ups. Select the MySQL driver and Finish. Now fill in important info. Windows DSN name: (pick whatever name you like for the database) MySQL host: mysql.example.com MySQL database name: exactly that User: your database username Password: your database password Now hit OK. You will need to repeat this for each database that you want to connect to via access. *
Start Access. Creat a new blank database. call it whatever. If you set up a system DSN for the users database, perhaps you want to name it users. Now you should have a blank window. Right click inside the window. Select “Link Tables”. You can also do this by clicking on the “New” tab and selecting “Link Table”. Now you get an open file box. On the bottom left, go to the drop down list for “Files of type:” and scroll all the way to the bottom. The last option should be ODBC Databases(). Select that. If it’s not there, you did something wrong and probably need to reinstall the drivers. Now another box pops up. Select Machine Data Source tab. You should see a list of the data sources you’ve set up. Pick whichever one you need.
We do offer a VPN service - if you set this up, MySQL / ODBC connections will automatically go over the VPN.