Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MySQL 5
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MySQL
Divers
Thread ID:
01086924
Message ID:
01089222
Vues:
19
Geoff,
here is what I have been able to do with MySQL and I assume would work for others.

1. Go to www.dyndns.org and sign up for the free Dynamic DNS service. This will give you a pointer to your server if it has a dynamic ip address. Most routers can be set up to send your new ip address to dyndns.org whenever your isp changes the ip address.

2. This is most important for security. Change the port address on your MySQL Server. The default is a four digit number. Change it to some five digit number. Google the port number with 'port nnnnn' to make sure it is not used by something important but any number that is five digits is, I believe, pretty much open. This is assuming you have a local server that you have compleate control over. If your server is at some hosting service then none of this will work.

3. Set the port forwarding on the router at the server end to forward that port to the server. The server ip address on the local network must be static for this to work reliably.

4. On the client end use the dyndns.org name you created and the new port address in the connection string.

This has worked for me.

>Hi John
>
>I would be interested in the checklist you mention. I assume that it would work for any database?
>
>
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform