How to add hosts to access MySQL database

[djtheme]

I want to access my database on server with my home computer which have dynamic IP adress (it changed every 2 days). So I need to add subnet in which changed my IP. Does your system allow to add subnet(not just one host) to access MySQL database???

maybe I can add something like 77.145.213.1/8
it's subnet 77.145.213.1-77.145.213.254 or 77.145.213.1/255.255.255.0

 

[ISREDES]

You can some dinamyp ip service as dyndns for create a host for your ips... is too simple, and can add the host (no the ip) to access host for you mysql.

 

[djtheme]

How I can do this

Thank you for advise but....

Where or even how I can do it????

Thanks again!!!!

 

[nobaloney]

See:

http://www.dyndns.com/

Jeff

 

[swisshuttles]

If anyone is looking for the solution to the original question they should know that the %-character is the wildcard.
So the right answer to the original question should be 77.145.213.%

I was having the same issue over ipv6.

 

[ericosman]

If anyone is looking for the solution to the original question they should know that the %-character is the wildcard.
So the right answer to the original question should be 77.145.213.%

I was having the same issue over ipv6.

This will become fun when there is a second mysql database in the 77.145.213.1-254 string

 

[swisshuttles]

This will become fun when there is a second mysql database in the 77.145.213.1-254 string

Don't quite understand your point. This thread is about external hosts (ip-addresses) which will be allowed to a specific database. I Don't see a problem when multiple hosts can connect to a single database when you wish too.

 

[ericosman]

Don't quite understand your point. This thread is about external hosts (ip-addresses) which will be allowed to a specific database. I Don't see a problem when multiple hosts can connect to a single database when you wish too.

If there are multiple mysql server in in the range of 77.145.213.1 - 254
Then it just tries the first one that it see's, if that would be my mysql server and not yours, you will get the error that it can not connect to the database.

If you own the complete subnet than sure, no problemo. But otherwise your website will work one moment and not the other.

 

[swisshuttles]

If there are multiple mysql server in in the range of 77.145.213.1 - 254
Then it just tries the first one that it see's, if that would be my mysql server and not yours, you will get the error that it can not connect to the database.

If you own the complete subnet than sure, no problemo. But otherwise your website will work one moment and not the other.

I'm still thinking you're missing the point. The option 'Access Hosts' is nothing more or less than a hosts.allow like registration for a specific database. It opens the possibility to connect to your database from an external resource.

The ip 77.145.213.* is a local ip of djtheme from which he want to connect to his database on another server running at whatever ip.
It has nothing to do with which database you will connect to from within your code. Off-course you need to set up a database connection to the proper server/url/ip from within your code. What else is new?

This is my last reply on this topic. Hope it wil help someone one day.