13 messages in com.mysql.lists.mysqlRe: bind-address by name under 5.0.18
FromSent OnAttachments
James Long22 Feb 2006 19:26 
sheeri kritzer27 Feb 2006 12:13 
James Long27 Feb 2006 12:58 
SGr...@unimin.com27 Feb 2006 13:23 
James Long27 Feb 2006 13:26 
SGr...@unimin.com27 Feb 2006 13:55 
James Long27 Feb 2006 14:48 
Jeremy Cole27 Feb 2006 18:07 
James Long27 Feb 2006 18:24 
Jeremy Cole27 Feb 2006 19:19 
James Long27 Feb 2006 20:16 
Jeremy Cole28 Feb 2006 14:00 
James Long28 Feb 2006 14:33 
Subject:Re: bind-address by name under 5.0.18
From:Jeremy Cole (jco@yahoo-inc.com)
Date:02/27/2006 07:19:30 PM
List:com.mysql.lists.mysql

Hi,

Thank you very much! I'm willing to help test if you can provide me a diff of your changes.

Well, that was easy. I checked the code, and it turns out that the functionality is already there. I just tested it on my laptop (running 5.0.13) and it does indeed work.

I did:

* echo "10.0.0.1 foo" >> /etc/hosts * ifconfig lo0 alias 10.0.0.1 * add to /etc/my.cnf: [mysqld] bind-address=foo * restart mysqld * mysql -h 10.0.0.1 <-- confirm connection or error from mysqld * mysql -h 127.0.0.1 <-- confirm failure to connect at all

I didn't know that this worked. Learn something new every day.

Are you having a problem with it? Does it not work for you?

Regards,

Jeremy