From owner-freebsd-questions Fri Mar 7 15:42:51 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 EF95D37B401 for ; Fri, 7 Mar 2003 15:42:48 -0800 (PST) Received: from lilbuddy.antsclimbtree.com (lilbuddy.antsclimbtree.com [216.27.183.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id DFAD543F3F for ; Fri, 7 Mar 2003 15:42:47 -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 18rRUh-0008t2-00; Fri, 07 Mar 2003 15:43:16 -0800 Date: Fri, 7 Mar 2003 15:42:45 -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: , , To: massey@rmci.net From: Mark Edwards In-Reply-To: <3462.216.222.104.2.1047079116.squirrel@webmail.velocitus.net> Message-Id: <7F1DB8F0-50F6-11D7-B239-0005025E566F@antsclimbtree.com> 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 I issued the necessary GRANT statements to add a new user, as described on that page, and I get: > mysql -u marktest -p -h antsclimbtree.com Enter password: ERROR 2013: Lost connection to MySQL server during query Same thing. Again, shouldn't the error message be different if this is a permissions problem? On Friday, March 7, 2003, at 03:18 PM, wrote: > http://www.mysql.com/doc/en/Adding_users.html > > >>> 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? >>> >>> That's what I get. lilbuddy.antsclimbtree.com is the hostname of the >>> server machine, and I'm doing this from that machine. >>> >>> Any idea what's wrong? Thanks! >>> >>> -- >>> Mark Edwards >>> San Francisco, CA >> >> >> >> >> To Unsubscribe: send mail to majordomo@FreeBSD.org >> with "unsubscribe freebsd-questions" in the body of the message > > > > -- 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