Re: mysql323-server -- can't connect remotely

[Mark Edwards]

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, <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message




--
Mark Edwards
Engineer
Mr. Toad's
San Francisco, CA
To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message