I had a similar problem recently. Try checking the /etc/hosts file to see if
the hosts/IPs are matching the current config.
Regards,
Milos Rackov
-----Original Message-----
From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2013: Lost connection to MySQL server during query
Hello,
I'm getting the error message above whenever I try to connect from a remote
host to a MySQL server. I issue the following command:
mysql --host=host_name -u user_name -ppass_word
and get the ERROR 2013 back as a response.
We have two servers, both running MySQL. I get the same message going both
ways. I have all the privileges set up properly. When I don't, I just get
the "host_name not set up for access" message. I've duplicated the setup on
our local LAN, and I connect with no problem. It is only our Web servers
that are having this problem.
We are only having this problem after our ISP moved our servers to a new,
"better" network and gave us new IPs. The servers have been talking to each
other with no problems for almost 1.5 years, but have not been able to since
the move. I've updated the privilege information, but it appears that the
client is not getting a complete response from the server.
Any ideas on what to do to fix this? Troubleshooting clues? The request from
the remote server is not showing up in the log; anyway I could capture this?
I can telnet between the systems so I'm pretty sure the TCP/IP is working.
MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2.
The mysqld variables are set to their default except for max_allowed_packet,
which has been increased to 10048512 on the 3.22.21 system in a vain attempt
to solve the error.
Thanks!
Kurt Hansen
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
