From: Daevid Vincent Date: October 8 2002 11:28pm Subject: RE: Remote Connection Probem List-Archive: http://lists.mysql.com/mysql/121692 Message-Id: <001b01c26f22$76677ca0$0500a8c0@telecom> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable I tried this and got a different result: [root@daevid root]# telnet 127.0.0.1 3306 =20 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. ?=04Host 'daevid' is not allowed to connect to this MySQL = serverConnection closed by foreign host. [root@daevid root]# telnet localhost 3306 =20 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. ?=04Host '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:skuss@stripped]=20 > Sent: Tuesday, October 08, 2002 11:04 AM > To: Ronald Petty > Cc: mysql@stripped > Subject: Re: Remote Connection Probem >=20 >=20 > Thanks for your response. > I tried to connect to the server via telnet as you suggested=20 > with the following result. >=20 > telnet my.machine.ip 3306 >=20 > Trying my.machine.ip... > Connected to my.machine.ip. > Escape character is '^]'. > Connection closed by foreign host. >=20 > Is this the behaivior I should expect, or am I correct to=20 > assume that the remote host should not terminate the=20 > connection. Somebody else on this list reported having the=20 > exact same problems after an upgrade from Redhat 7 to Redhat=20 > 8 in response to my post. Any more ideas of what could be wrong? >=20 >=20 > ----- Original Message ----- > From: "Ronald Petty" > To: "Stefan Kuss" ; > Sent: Monday, October 07, 2002 10:59 PM > Subject: Re: Remote Connection Probem >=20 >=20 > > 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=20 > MySQL from the > local > >>machine without any problem and I created a user with remote login=20 > >>privileges. Trying to connect to it from another machine=20 > (on the same=20 > >>network as well as the same subnet) gives "ERROR: 10061=20 > Connection to > mysql > >>server failed." I have no problems connecting to the linux=20 > machine via > hhtp, > >>ftp, and ssh and a port scan shows that MySQL is infact=20 > running on the=20 > >>remote machine (default port 3306). Has anyone heard of similar=20 > >>problems > and > >>an idea of how to solve this? > >> > >>-Stefan >=20 >=20 >=20 > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) >=20 > To request this thread, e-mail > To unsubscribe, e-mail=20 > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >=20