MySQL "bind-address", auto-bind

Is there a way to have MySQL automatically detect the IP address of the machine it's on and set the "bind-address" configuration variable itself? This is a small home server using DHCP that's used periodically and I really don't want to go through setting up static IP addresses.

http://dev.mysql.com/doc/refman/5.0/en/ ... rties.html

I've never done what you're trying to do (not sure if I even completely understand what you're trying to do), but hope that helps.

Basically in "/etc/mysql/my.cnf", there is a configuration variable called "bind-address" which tells MySQL servers which IP address on the machine to bind to. The variable is set during the MySQL installation.

In my case, the IP address of the machine will change now and then. If I start the server and DHCP has given the machine a different address, MySQL will fail to start until I edit my.cnf and update the IP address.

This machine will only ever have one IP address at a time, so I'm hoping it is possible to have MySQL be smart enough to say hey, there's only one address available anyways, let's just bind to that.

You should be able to set to it to 'bind-address = 0.0.0.0' and it will bind to what ever it can.

Worked like a charm, Spoof. Thank you.