MySQL Forums
Forum List  »  Newbie

remote connection issue
Posted by: liran kessel
Date: December 20, 2016 02:28AM

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

Options: ReplyQuote


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.