Greetings

So far as I can see it's possible to set MySQL to listen on /ONE/ or /ALL/
IP-Addresses.

Anyone know if (and how) MySQL can be configured to listen on a particular
set of addresses?

Ta-ra-a-bit
--
William Tasso

William Tasso wrote

> Greetings

How do you do?  (TM you)

> So far as I can see it's possible to set MySQL to listen on /ONE/ or
> /ALL/  IP-Addresses.
>
> Anyone know if (and how) MySQL can be configured to listen on a
> particular  set of addresses?

Not answering your question of course, but would it be an option to have it
accept all connections, but only allow particular ones through the
firewall?

--
Charles Sweeney
http://CharlesSweeney.com

William Tasso wrote:

> Greetings
>
> So far as I can see it's possible to set MySQL to listen on /ONE/ or /ALL/
> IP-Addresses.
>
> Anyone know if (and how) MySQL can be configured to listen on a particular
> set of addresses?
>
> Ta-ra-a-bit


It's the bind-address=IP option.  Google for more.


--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png

Brian Wakem wrote

> William Tasso wrote:
> 
>
>
> It's the bind-address=IP option.  Google for more.

Doesn't that just allow for "one or all" IP addresses (by specifying an IP
or commenting out the line) as Mr T indicated?

--
Charles Sweeney
http://CharlesSweeney.com

Fleeing from the madness of the No thank you jungle
Charles Sweeney <me@charlessweeney.com> stumbled into
news:alt.www.webmaster
and said:

> William Tasso wrote
> 
>
> How do you do?  (TM you)

and what a jolly fine day it is too.
 
>
> Not answering your question of course, but would it be an option to have
> it
> accept all connections, but only allow particular ones through the
> firewall?

Thanks for the thought, but that is the current arrangement.

Hoping for additional tightening of availability /inside/ the firewall.

--
William Tasso

http://williamtasso.com/words/what-is-usenet.asp

Fleeing from the madness of the No thank you jungle
Charles Sweeney <me@charlessweeney.com> stumbled into
news:alt.www.webmaster
and said:

> Brian Wakem wrote
> 

s/e led me here :)

> Doesn't that just allow for "one or all" IP addresses (by specifying an
> IP
> or commenting out the line) as Mr T indicated?

that is my understanding of the documentation.

--
William Tasso

http://williamtasso.com/words/what-is-usenet.asp

"William Tasso" <SpamBlocked@tbdata.com> wrote in news:op.tatmmq0lm9g4qz-
wnt@tbdata.com:

> Subject: Re: MySQL availability
> From: "William Tasso" <SpamBlocked@tbdata.com>
> Newsgroups: alt.www.webmaster
> Reply-To: usenet
>
> Fleeing from the madness of the No thank you jungle
> Charles Sweeney <me@charlessweeney.com> stumbled into
> news:alt.www.webmaster
> and said:
> 
>
> and what a jolly fine day it is too.


it's another fine day here too.

I suspect that it must be in the low to mid 70s and tis only 11.25am

William Tasso wrote:

> Greetings
>
> So far as I can see it's possible to set MySQL to listen on /ONE/ or
> /ALL/ IP-Addresses.

I was trying to work this out the other day myself and you are correct,
it can currently only be configured to listen on one or all.

> Anyone know if (and how) MySQL can be configured to listen on a
> particular set of addresses?

At the present time it can't. From the searching I was doing the other
day it appears to be something that may be implemented in the future.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

Fleeing from the madness of the  jungle
Chris Hope <blackhole@electrictoolbox.com> stumbled into
news:alt.www.webmaster
and said:

> William Tasso wrote: 
>
> I was trying to work this out the other day myself and you are correct,
> it can currently only be configured to listen on one or all.

oh good - glad it's not just me.
 
>
> At the present time it can't. From the searching I was doing the other
> day it appears to be something that may be implemented in the future.

aha - thanks for the heads-up.

--
William Tasso

http://williamtasso.com/words/what-is-usenet.asp