Gentoo Archives: gentoo-user

From: Peter Humphrey <peter@××××××××××××××.org>
To: gentoo-user@l.g.o
Subject: [gentoo-user] Network access to MySQL
Date: Tue, 29 Apr 2008 09:51:49
Message-Id: 200804291051.30317.peter@humphrey.ukfsn.org
1 Having just installed mysql on my server, I've found that I have to set
2 bind-address = 0.0.0.0 in /etc/mysql/my.cnf to enable me to connect to
3 mysqld over the local network: leaving it at the default 127.0.0.1 causes
4 connection requests to be rejected.
5
6 Is there a more secure value for this parameter? I want to be able to
7 connect over either of two network segments, 192.168.2.0/29 and
8 192.168.3.0/29, as well as locally on the server box. I've tried a compound
9 setting in bind-address, but mysqld then refuses to start. 0.0.0.0 is the
10 only setting I've found so far that lets me in.
11
12 --
13 Rgds
14 Peter
15 --
16 gentoo-user@l.g.o mailing list

Replies

Subject Author
Re: [gentoo-user] Network access to MySQL Hamish <hamish@××××××××××××××.com>
Re: [gentoo-user] Network access to MySQL kashani <kashani-list@××××××××.net>