Re: [brisbane-webtech] Help with Internet Setup

From: Arjen L.
Sent on: Monday, August 6, 2012 8:01 PM
Hi Don

> I have a MySql database on a server and being connected to by several
> people using an MS Access front end from their PCs which have dynamic
> IP addresses.
> 
> Within MySql we have to nominate the Remote Host IPs which can connect
> to the database. We could put % to accommodate the variable IP
> addresses but that is not a good security practice.
> 
> I understand this can be accommodated by using either a Dynamic Domain
> Name System or port forwarding with SSH or a Virtual Private Network
> and in the Remote Hosts you put a list of the hosts that are permitted
> through the firewall.
> 
> Has anyone done this? I’m looking for paid help to set it up.

A VPN sounds like the most appropriate approach in this case.
With a VPN the remote users will be on a single (local) subnet, and then you can set the authorisation in MySQL to allow user names connecting from within that subnet.

Cheers,
Arjen.
-- 
Exec.Director @ Open Query (http://openquery....­) MySQL services
Sane business strategy explorations at http://Upstarta.b...­
Personal blog at http://lentz.com....­

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy