MarkP
04-12-2008, 02:14 PM
Background - Not all relevent!
Hi, I'm kinda a newbie, I've been experimenting for a short time with MySql. I'm supposed to be writing a simple front end in VB6 and thought MySql would be a solid database to use as it will be accessed remotely from users in Germany and different parts of the UK. I'm starting from the ground up and learning as I go, I've done a bit with VB6 but not MySql or hosting databases for remote access.
The problem
I've whitelisted my IP to get access which I can do using MySql Query Browser and also VB6 but after re-booting my router I find the IP had changed. I thought I'd solve the hassle of re-adding the IP by adding the class C instead thinking that would be like adding a range but that didn't work either. The IP was not of the same subnet if that is the correct terminolgy. I'm thinking of the bigger picture for me and my use of the database, this could happen frequently for the users of the database, it needs to be automated as I can't be available to whitelist it for them or expect them to have to do it themselves. Is there any work arounds or settings that can be changed. I've got code in VB which will tell me the external IP but I don't know what to do with it if indeed there is anything that can be done.
Any suggestions would be greatly welcomed,
Many Thanks
Mark.
Hi, I'm kinda a newbie, I've been experimenting for a short time with MySql. I'm supposed to be writing a simple front end in VB6 and thought MySql would be a solid database to use as it will be accessed remotely from users in Germany and different parts of the UK. I'm starting from the ground up and learning as I go, I've done a bit with VB6 but not MySql or hosting databases for remote access.
The problem
I've whitelisted my IP to get access which I can do using MySql Query Browser and also VB6 but after re-booting my router I find the IP had changed. I thought I'd solve the hassle of re-adding the IP by adding the class C instead thinking that would be like adding a range but that didn't work either. The IP was not of the same subnet if that is the correct terminolgy. I'm thinking of the bigger picture for me and my use of the database, this could happen frequently for the users of the database, it needs to be automated as I can't be available to whitelist it for them or expect them to have to do it themselves. Is there any work arounds or settings that can be changed. I've got code in VB which will tell me the external IP but I don't know what to do with it if indeed there is anything that can be done.
Any suggestions would be greatly welcomed,
Many Thanks
Mark.