remote connection issue
Hi,
I have a Mysql server installed on server X, I have configured the server to allow remote connects from all servers.
I am trying to connect remotely from 2 different servers, from 1 I get a prompt , while from the other I don't get a prompt and don't get any error.
When I telnet to the mysql server on port 3306 , from the first server I get this output
telnet 192.168.166.102 3306
Trying 192.168.166.102...
Connected to 192.168.166.102 (192.168.166.102).
Escape character is '^]'.
8
5.1.73-logw~739eoYxrQ~I0S3D<>
However when I telnet from the other server I am connected but don't get the version
telnet 192.168.166.102 3306
Trying 192.168.166.102...
Connected to 192.168.166.102 (192.168.166.102).
Escape character is '^]'.
and is stuck in this status.
I can also see in the mysql server that my server is connected
netstat -an |grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 192.168.166.102:3306 192.168.138.65:37333 SYN_RECV
From my understanding this isn't a firewall problem as the connection is created.
can anyone assist me with understanding what I have done incorrectly in the mysql configuration?
Thanks in advance
Liran
Subject
Written By
Posted
remote connection issue
December 20, 2016 02:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.