<div>
Thanks for the comment. &nbsp; &nbsp;I am thinking of using SSH tunnel. &nbsp; Would that be better?
</div>


Thanks for the comment.    I am thinking of using SSH tunnel.   Would that be better?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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. &nbsp;I have tried this by setting up a remote DSN using MyODBC and it seems to work well. &nbsp;The only thing I am concerned about is security. &nbsp; &nbsp; I am aware that you can set passwords and limit IP addresses. &nbsp;I am aware that the data is not encrypted. &nbsp; &nbsp; Are there real security issues with this? &nbsp; &nbsp; &nbsp;How can I resolve these? &nbsp; &nbsp;Can I use a VPN and/or firewall to improve security? &nbsp;One limiting factor is that it has to work over a 56K connection.
</div>
</div>


Hi,

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.

MySQL/MyODBC Remote Access Security

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.