Andrew wrote: > Hi Everyone, > > I have been searching around for a while, but have had no luck as yet > for this question. > > I am running debian with mysql 4.x on a x86 box. (2.6 series kernel). > > Anyhow, up until now, I have had a single bind-address option passed, > however I need to add another address (so it binds to two, but not all > available addresses) - how can I do this in the my.cnf file? > > > > Thanks, > > ANdrew.
Hi Andrew, judging by a quick look at the source of 5.0.18, I would say, that this is not possible. You can either bind to one or all addresses. Cheers Frank see sql/mysqld.cc: case (int) OPT_BIND_ADDRESS: if ((my_bind_addr= (ulong) inet_addr(argument)) == INADDR_NONE) { struct hostent *ent; if (argument[0]) ent=gethostbyname(argument); else { char myhostname[255]; if (gethostname(myhostname,sizeof(myhostname)) < 0) { sql_perror("Can't start server: cannot get my own hostname!"); exit(1); } ent=gethostbyname(myhostname); } if (!ent) { sql_perror("Can't start server: cannot resolve hostname!"); exit(1); } my_bind_addr = (ulong) ((in_addr*)ent->h_addr_list[0])->s_addr; } break; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]