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]