I tried this and got a different result: [root@daevid root]# telnet 127.0.0.1 3306 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. ?Host 'daevid' is not allowed to connect to this MySQL serverConnection closed by foreign host.
[root@daevid root]# telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. ?Host 'daevid' is not allowed to connect to this MySQL serverConnection closed by foreign host. [root@daevid root]# telnet daevid.com 3306 Trying 12.228.95.58... mysql> select * from host ; +-------------+----+-------------+-------------+-------------+---------- ---+-------------+-----------+------------+-----------------+----------- -+------------+ | Host | Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-------------+----+-------------+-------------+-------------+---------- ---+-------------+-----------+------------+-----------------+----------- -+------------+ | localhost | % | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | 192.168.0.% | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | %daevid% | % | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | +-------------+----+-------------+-------------+-------------+---------- ---+-------------+-----------+------------+-----------------+----------- -+------------+ 3 rows in set (0.00 sec) > -----Original Message----- > From: Stefan Kuss [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 11:04 AM > To: Ronald Petty > Cc: [EMAIL PROTECTED] > Subject: Re: Remote Connection Probem > > > Thanks for your response. > I tried to connect to the server via telnet as you suggested > with the following result. > > telnet my.machine.ip 3306 > > Trying my.machine.ip... > Connected to my.machine.ip. > Escape character is '^]'. > Connection closed by foreign host. > > Is this the behaivior I should expect, or am I correct to > assume that the remote host should not terminate the > connection. Somebody else on this list reported having the > exact same problems after an upgrade from Redhat 7 to Redhat > 8 in response to my post. Any more ideas of what could be wrong? > > > ----- Original Message ----- > From: "Ronald Petty" <[EMAIL PROTECTED]> > To: "Stefan Kuss" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, October 07, 2002 10:59 PM > Subject: Re: Remote Connection Probem > > > > Try this > > telnet yourmachine 3306 > > > > If you do not get something like > > Trying yourmachine > > Conneced to yourmachine > > Escape character is '^]'. > > (then sits there on a blank line) > > > > Your port is not open, > > Ron > > > > > > > >> > >>Hi, > >> > >>I am running MySQL 3.23 on Redhat 8.0. I can connect to > MySQL from the > local > >>machine without any problem and I created a user with remote login > >>privileges. Trying to connect to it from another machine > (on the same > >>network as well as the same subnet) gives "ERROR: 10061 > Connection to > mysql > >>server failed." I have no problems connecting to the linux > machine via > hhtp, > >>ftp, and ssh and a port scan shows that MySQL is infact > running on the > >>remote machine (default port 3306). Has anyone heard of similar > >>problems > and > >>an idea of how to solve this? > >> > >>-Stefan > > > > --------------------------------------------------------------------- > 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
