List:General Discussion« Previous MessageNext Message »
From:sheeri kritzer Date:February 27 2006 8:13pm
Subject:Re: bind-address by name under 5.0.18
View as plain text  
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 <james_mapson@stripped> 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/mysql?unsub=1
>
>
Thread
bind-address by name under 5.0.18James Long23 Feb
  • Re: bind-address by name under 5.0.18sheeri kritzer27 Feb
    • Re: bind-address by name under 5.0.18James Long27 Feb
      • Re: bind-address by name under 5.0.18SGreen27 Feb
        • Re: bind-address by name under 5.0.18James Long27 Feb
          • Re: bind-address by name under 5.0.18SGreen27 Feb
            • Re: bind-address by name under 5.0.18James Long27 Feb
  • Re: bind-address by name under 5.0.18Jeremy Cole28 Feb
Re: bind-address by name under 5.0.18James Long28 Feb
  • Re: bind-address by name under 5.0.18Jeremy Cole28 Feb
    • Re: bind-address by name under 5.0.18James Long28 Feb
      • Re: bind-address by name under 5.0.18Jeremy Cole28 Feb
        • Re: bind-address by name under 5.0.18James Long28 Feb