From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([69.77.167.62] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1JqmV3-0000k1-08 for garchives@archives.gentoo.org; Tue, 29 Apr 2008 09:51:49 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 99F96E0436; Tue, 29 Apr 2008 09:51:45 +0000 (UTC) Received: from mail.ukfsn.org (mx1.ukfsn.org [77.75.108.10]) by pigeon.gentoo.org (Postfix) with ESMTP id 75389E0436 for ; Tue, 29 Apr 2008 09:51:45 +0000 (UTC) Received: from localhost (smtp-filter.ukfsn.org [192.168.54.205]) by mail.ukfsn.org (Postfix) with ESMTP id A14D1DEC5C for ; Tue, 29 Apr 2008 10:54:23 +0100 (BST) Received: from mail.ukfsn.org ([192.168.54.25]) by localhost (smtp-filter.ukfsn.org [192.168.54.205]) (amavisd-new, port 10024) with ESMTP id KUjNAlVAnqJW for ; Tue, 29 Apr 2008 10:33:03 +0100 (BST) Received: from wstn.ethnet (78-32-181-186.no-dns-yet.enta.net [78.32.181.186]) by mail.ukfsn.org (Postfix) with ESMTP id DC62CDEC05 for ; Tue, 29 Apr 2008 10:54:21 +0100 (BST) From: Peter Humphrey Organization: at home To: gentoo-user@lists.gentoo.org Subject: [gentoo-user] Network access to MySQL Date: Tue, 29 Apr 2008 10:51:30 +0100 User-Agent: KMail/1.9.7 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200804291051.30317.peter@humphrey.ukfsn.org> X-Archives-Salt: 2512f2c0-084f-4340-9737-af3512d0fdd9 X-Archives-Hash: ef038c1dc3d573d49379eaff1d6208bc 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@lists.gentoo.org mailing list