[AccessD] mysql views and dynamic IP address

[Kostas Konstantinidis]

Hi Stuart and Gustav

Thank's both
/kostas

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Wednesday, December 09, 2015 12:18 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] mysql views and dynamic IP address

Hi Kostas and Stuart

Problem is, that most of these services are either not free or require a
regular manual confirmation or the like - to bother you that much that you
sign up for a paid account.

After quite a lot of research, I found this service from UBLink (a Draytek
dealer) several years ago, which is plain and free and never has failed:

    http://ubddns.org

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
Stuart McLachlan
Sendt: 9. december 2015 00:08
Til: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Emne: Re: [AccessD] mysql views and dynamic IP address

DynDNS?
or an alterenative:
http://lifehacker.com/the-best-free-alternatives-to-dyndns-1561556205

Then use a name rather than an IP address



On 8 Dec 2015 at 14:02, Kostas Konstantinidis wrote:

> Hi all,
> 
> e.g.
> 
> CREATE 
>     ALGORITHM = UNDEFINED 
>     DEFINER = `kost36_kostas`@`79.130.194.123` 
>     SQL SECURITY DEFINER
> 
> I use a dynamic IP so every time I try to synchronize the databases if 
> my IP has been changed I have to update all the views one by one with 
> the new IP Is there any other better way to do that bypassing the IP 
> address?
> 
> Thank's
> /kostas

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com