[AccessD] mysql views and dynamic IP address

[Stuart McLachlan]

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
>