Date: Fri, 7 Mar 2003 15:42:45 -0800 From: Mark Edwards <mark@antsclimbtree.com> To: massey@rmci.net Cc: <la3sg@sensewave.com>, <junkmail@sensewave.com>, <questions@freebsd.org> Subject: Re: mysql323-server -- can't connect remotely Message-ID: <7F1DB8F0-50F6-11D7-B239-0005025E566F@antsclimbtree.com> In-Reply-To: <3462.216.222.104.2.1047079116.squirrel@webmail.velocitus.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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, <massey@rmci.net> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?7F1DB8F0-50F6-11D7-B239-0005025E566F>