MySQL/MyODBC Remote Access Security
Posted on 2004-04-14
I am looking at sharing a small (2Mb) DB across several sites over the internet using an MS Access front end and MySQL back end. I have tried this by setting up a remote DSN using MyODBC and it seems to work well. The only thing I am concerned about is security. I am aware that you can set passwords and limit IP addresses. I am aware that the data is not encrypted. Are there real security issues with this? How can I resolve these? Can I use a VPN and/or firewall to improve security? One limiting factor is that it has to work over a 56K connection.