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 1LSD2q-0001k1-EV for garchives@archives.gentoo.org; Wed, 28 Jan 2009 16:13:40 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 02BC9E0492; Wed, 28 Jan 2009 16:13:39 +0000 (UTC) Received: from mail.ukfsn.org (mail.ukfsn.org [77.75.108.10]) by pigeon.gentoo.org (Postfix) with ESMTP id D0906E0492 for ; Wed, 28 Jan 2009 16:13:38 +0000 (UTC) Received: from localhost (smtp-filter.ukfsn.org [192.168.54.205]) by mail.ukfsn.org (Postfix) with ESMTP id 28389DEE13 for ; Wed, 28 Jan 2009 16:13:41 +0000 (GMT) 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 9YftpLU9zDeM for ; Wed, 28 Jan 2009 14:52:35 +0000 (GMT) Received: from wstn.ethnet (unknown [78.32.181.186]) by mail.ukfsn.org (Postfix) with ESMTP id E698BDECE7 for ; Wed, 28 Jan 2009 16:13:40 +0000 (GMT) From: Peter Humphrey Organization: at home To: gentoo-user@lists.gentoo.org Subject: [gentoo-user] Network access to mysql Date: Wed, 28 Jan 2009 16:13:37 +0000 User-Agent: KMail/1.9.9 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-Disposition: inline Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <200901281613.37159.peter@humphrey.ukfsn.org> X-Archives-Salt: 71d2c4a4-3413-414b-8261-39ab481b39a2 X-Archives-Hash: 34dc333d1e67b6fce17809fabbbaa145 Afternoon all, I have mysql running on my workstation and on my local server, and I want to connect as an ordinary user from the workstation to the server; I can't. This is what happens: $ mysql -p -h serv.ethnet Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 'serv.ethnet' (111) The same thing happens if I try as root. I can connect locally as myself or as root on either machine and manipulate tables in various ways. I haven't yet installed a firewall on either machine. I've set DEBUG=4 in /etc/conf.d/mysql on both machines, but nothing shows up in /var/log/mysql/*; only some startup debug messages. I've run tcpdump on the server, which shows that one packet passes in each direction, followed immediately by a reverse lookup of the workstation being sent to the name server. I don't know why nothing happens after the name-service request is answered, but it seems to imply that the workstation is refusing the request itself rather than forwarding it to the server. I can't see anything in /etc/conf.d/mysql or in /etc/mysql/* on either machine to restrict network access, so what have I missed? -- Rgds Peter