Network access to MySQL

8 msg	[OT]batch processing html files
16 msg	skype notworking
6 msg	subscribe
3 msg	Linux box -> Checkpoint Firewall
27 msg	strange blocks b behavior
8 msg	2008.0 profile
4 msg	Lilo error when booting to windows
56 msg	smoothest way to jump from 2006 to 2008
9 msg	pptp client under nat

Network access to MySQL
\ Peter Humphrey (29 Apr 2008)
. \ Hamish (29 Apr 2008)
. \ kashani (29 Apr 2008)
. . \ Mick (29 Apr 2008)
. . . \ Peter Humphrey (3 May 2008)

13 msg	lyx & texlive
1 msg	HP dv9000 video hang
3 msg	different strange kernel name - 2.6.24-gentoo-r...
8 msg	ftdi usb-serial converter broken
6 msg	portage nfs permissions
1 msg	Baselayout 2 - one more (unpleasant) surprise
6 msg	sys-libs/-MERGING-pam
6 msg	emerge virtual/emacs fails
1 msg	test
7 msg	Portage -> touch files

Subject:	Network access to MySQL
Group:	Gentoo-user
From:	Peter Humphrey
Date:	29 Apr 2008

Having just installed mysql on my server, I've found that I have to set
bind-address = 0.0.0.0 in /etc/mysql/my.cnf to enable me to connect to
mysqld over the local network: leaving it at the default 127.0.0.1 causes
connection requests to be rejected.

Is there a more secure value for this parameter? I want to be able to
connect over either of two network segments, 192.168.2.0/29 and
192.168.3.0/29, as well as locally on the server box. I've tried a compound
setting in bind-address, but mysqld then refuses to start. 0.0.0.0 is the
only setting I've found so far that lets me in.

--
Rgds
Peter
--
gentoo-user mailing list