RE: mysql connection refused or lost (Update)

2003-03-07 Thread Charlie H.
 When I try telnet localhost 3306 all seems ok. When I try
 telnet domain.com 3306 I get the message Connection closed by foreign
 host, same goes when trying the IP address from the local box. If I try
 this as well from a remote box, I get Connection closed by foreign host.



I believe I have figured out most of the problem with the connectin refused.
I still have a problem with lost connections from a remote box and trying to
connect via the IP address locally.

mysql -u sat -h domain.com test (works)

mysql -u sat -h IPAddress test
ERROR 2013: Lost connection to MySQL server during query

When I try to connect to this box from another box which I have granted all
rights, I get the error:
ERROR 2013: Lost connection to MySQL server during query

Any help will be greatly appreciated.
Charlie


-
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



Re: mysql connection refused or lost (Update)

2003-03-07 Thread [EMAIL PROTECTED]
Charlie H. schrieb:
When I try telnet localhost 3306 all seems ok. When I try
telnet domain.com 3306 I get the message Connection closed by foreign
host, same goes when trying the IP address from the local box. If I try
this as well from a remote box, I get Connection closed by foreign host.


I believe I have figured out most of the problem with the connectin refused.
I still have a problem with lost connections from a remote box and trying to
connect via the IP address locally.
mysql -u sat -h domain.com test (works)

mysql -u sat -h IPAddress test
ERROR 2013: Lost connection to MySQL server during query
When I try to connect to this box from another box which I have granted all
rights, I get the error:
ERROR 2013: Lost connection to MySQL server during query
Any help will be greatly appreciated.
Charlie
-
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



https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467

 lost connection ...
[mysqld]
set-variable=thread_stack=256k
--
shrek-m
-
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


RE: mysql connection refused or lost (Update)

2003-03-07 Thread Charlie H.

 
  When I try to connect to this box from another box which I have 
 granted all
  rights, I get the error:
  ERROR 2013: Lost connection to MySQL server during query
 


 
 https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467
 
   lost connection ...
 [mysqld]
 set-variable=thread_stack=256k
 

Thanks! Life is good again :)
Best Wishes,
Charlie


-
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



mysql connection refused or lost

2003-03-06 Thread Charlie H.
Hi,

I have searched the archives and unfortunately could not find a solution to
my problem. I have setup a machine as a mysql server and cannont connect to
it remotely. When I try telnet localhost 3306 all seems ok. When I try
telnet domain.com 3306 I get the message Connection closed by foreign
host, same goes when trying the IP address from the local box. If I try
this as well from a remote box, I get Connection closed by foreign host.

I have setup a user for the remote box and granted all rights to this user,
using the IP address of the remote box. I am not sure if the software
firewall here is causing some problems or if it is something I am missing
with MySQL.

Best Wishes,
Charlie


-
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