It doesn't allow to bind to a hostname. According to http://dev.mysql.com/doc/refman/5.0/en/server-options.html
you have to specify an IP address, not a hostname. -Sheeri On 2/22/06, James Long <[EMAIL PROTECTED]> wrote: > I would like to be able to bind to a host name, rather than > an IP number. IP numbers come and go, and are beyond the > control of anyone who doesn't have their own direct allocation. > But since I own my domain, a host name is more permanent. > > When the time comes to change IP numbers, I want to just edit > /etc/hosts to show my new IP: > > 10.0.0.10 shortname myrealname.example.com > > and use "--bind-address=shortname" in my start-up script to > automatically pick up the new IP number. > > This eliminates the headache of having to find and fix umpteen > literal IP numbers hiding in my startup scripts. This is much > the same reason one says '#define BLKSIZ 512' and then uses the > constant 'BLKSIZ' instead of sprinkling literal '512's throughout > one's code). > > Why doesn't bind-address allow this? Or if it does, how can I > accomplish this? > > > Thanks! > > > Jim > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]