From owner-freebsd-questions Fri Mar 7 15:24:31 2003 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 54D7637B401 for ; Fri, 7 Mar 2003 15:24:30 -0800 (PST) Received: from lilbuddy.antsclimbtree.com (lilbuddy.antsclimbtree.com [216.27.183.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6E3BB43FB1 for ; Fri, 7 Mar 2003 15:24:27 -0800 (PST) (envelope-from mark@antsclimbtree.com) Received: from adsl-66-122-112-170.dsl.snfc21.pacbell.net ([66.122.112.170] helo=dina) by lilbuddy.antsclimbtree.com with asmtp (TLSv1:DES-CBC3-SHA:168) (Exim 4.12) id 18rRCw-0008qN-00; Fri, 07 Mar 2003 15:24:54 -0800 Date: Fri, 7 Mar 2003 15:24:24 -0800 Subject: Re: mysql323-server -- can't connect remotely Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v482) Cc: questions@freebsd.org To: la3sg@sensewave.com From: Mark Edwards In-Reply-To: <3E692C74.25002.369517B@localhost> Message-Id: Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.482) Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Friday, March 7, 2003, at 02:34 PM, Kjell wrote: >> I have /usr/ports/databases/mysql323-server installed, and it is up and >> running. If I do: >> >> >>> mysql -h localhost >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 1 to server version: 3.23.55 >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> >> >> >> It works fine. However, if I do: >> >> >>> mysql -h lilbuddy.antsclimbtree.com >> ERROR 2013: Lost connection to MySQL server during query >> > Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and db > tables in your mysql database? Yes, the test database and the anonymous user are accessible from any host. In any case, I believe the error would be ERROR 1130: Host 'lilbuddy.antsclimbtree.com' is not allowed to connect to this MySQL server if that was the problem. -- Mark Edwards Engineer Mr. Toad's San Francisco, CA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message