Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 7 Mar 2003 15:24:24 -0800
From:      Mark Edwards <mark@antsclimbtree.com>
To:        la3sg@sensewave.com
Cc:        questions@freebsd.org
Subject:   Re: mysql323-server -- can't connect remotely
Message-ID:  <EED9C2BB-50F3-11D7-B239-0005025E566F@antsclimbtree.com>
In-Reply-To: <3E692C74.25002.369517B@localhost>

next in thread | previous in thread | raw e-mail | index | archive | help

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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?EED9C2BB-50F3-11D7-B239-0005025E566F>