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 1LSDHK-0003BT-9g for garchives@archives.gentoo.org; Wed, 28 Jan 2009 16:28:38 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 7CBC0E0474; Wed, 28 Jan 2009 16:28:37 +0000 (UTC) Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by pigeon.gentoo.org (Postfix) with ESMTP id 1022DE0474 for ; Wed, 28 Jan 2009 16:28:36 +0000 (UTC) Received: by fg-out-1718.google.com with SMTP id d23so649302fga.14 for ; Wed, 28 Jan 2009 08:28:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=qY1/2I5Pj8UuBul8jtHUQo1WcjcBJCgisAbgaIV5dHc=; b=IxWKX1O6pypUTmMSAHKWaKXkZ8pQSCPUWIqlWHriobcZ8qAkCcA/fbR0eQeGXsSU67 VjsLGMbwt9d/+xixkDmC3vE5sdx83NHmhvnjTOujeAe9ILec1PKMQlexLoKm7WM3mIwG Ry3ycae5MG/LziSHtfzBpKAvvdKMX5Fdme4+0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=RdjGkhGiuk1bEbZ8NZsgf4pY0Yj+rb2GmBQbqD34GyaDTBQlpiARp0EQ68hPlt83Lm sQOnoq02blwPlWhucY1wJW2lMyJD5kzF9sbbbGKu3ZvIz02ZgnltFOXAjqlEaaAugxDF E9WyvUpIuw2kqtGCPhjN/FHTJRgQhXFNWmlGg= 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 Received: by 10.180.255.1 with SMTP id c1mr488612bki.36.1233160116319; Wed, 28 Jan 2009 08:28:36 -0800 (PST) In-Reply-To: <498086EC.3060403@allenjb.me.uk> References: <200901281613.37159.peter@humphrey.ukfsn.org> <498086EC.3060403@allenjb.me.uk> Date: Wed, 28 Jan 2009 14:28:36 -0200 Message-ID: <60a795cd0901280828n651a873ei5c5318398a99b54@mail.gmail.com> Subject: Re: [gentoo-user] Network access to mysql From: Alejandro To: gentoo-user@lists.gentoo.org Content-Type: multipart/alternative; boundary=001636c5bdc4af34d504618d76dc X-Archives-Salt: d558e05d-63f4-425d-8abe-c477e0b2b1c5 X-Archives-Hash: ee664fc209310122c1b8e16e58b578cc --001636c5bdc4af34d504618d76dc Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 2009/1/28 AllenJB > Peter Humphrey wrote: > >> 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? >> >> > Check the bind-address setting in /etc/my.cnf - if this is 127.0.0.1 then > no other machines will be able to connect to the mysql server. To listen on > all available interfaces, this setting should be "0.0.0.0" or unset. > > Also check that skip-networking is not enabled. > > Too late for me. --001636c5bdc4af34d504618d76dc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

2009/1/28 AllenJB <= gentoo-lists@allenjb.me.uk>
Peter Humphrey wrote:
Afternoon all,

I have mysql running on my workstation and on my local server, and I want t= o 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&#= 39; (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 m= achine.

I've set DEBUG=3D4 in /etc/conf.d/mysql on both machines, but nothing s= hows 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 directio= n, followed immediately by a reverse lookup of the workstation being sent t= o the name server. I don't know why nothing happens after the name-serv= ice request is answered, but it seems to imply that the workstation is refu= sing 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?


Check the bind-address setting in /etc/my.cnf - if this is 127.0.0.1 then n= o other machines will be able to connect to the mysql server. To listen on = all available interfaces, this setting should be "0.0.0.0" or uns= et.

Also check that skip-networking is not enabled.

Too late for me.
--001636c5bdc4af34d504618d76dc--