Cannot Connect to Port 3306 MySql Server on Centos from Windows

Asked Feb 18 '17 at 23:37

Active Feb 18 '17 at 23:37

Viewed 1,625 times

I am trying to play around with MySql on a CentOs7 Server, mostly by ssh on a Windows machine. I cannot seem to connect on to port 3306 from DBVisualizer which I am running on the Windows side. I receive the following error in the DBVisualizer GUI:

An error occurred while establishing the connection:

Long Message:
Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Details:
   Type: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
   SQL State: 08S01

I have no problem sshing through port 22. There are a number of posts on this matter including these and others from UnixStack:

Can't connect to MySQL server on (ip or domain name)

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure

I have taken a look at each and tried to implement them but nothing seems to be working. I have reconfigured the iptables a number of times. I have run nmap on the ports with this output.

Not shown: 997 closed ports
PORT     STATE SERVICE
22/tcp   open  ssh
25/tcp   open  smtp
3306/tcp open  mysql
No exact OS matches for host (If you know what OS is running on it, see http://nmap.org/submit/ ).

The second post did suggest that it could be JDBC issues, but I am not exactly sure how to check that, especially since I am trying to connect through an IDE.

edited May 23 '17 at 12:09

Community

asked Feb 18 '17 at 23:37

Jack Frye

did you check firewall rules? – vladkras Feb 18 '17 at 23:39
@vladkras that's what the IPTables are showing you – djthoms Feb 18 '17 at 23:39
i stopped firewalld with systemctl – Jack Frye Feb 18 '17 at 23:41
1

@djthoms my bad, I thought it was `netstat`, @JackFrye can you connect with `telnet`? – vladkras Feb 18 '17 at 23:42
that's what I am not sure about. I would think dbvisualizer would use tcp. Isnt that what is used to do remote connections to mysqldb? – Jack Frye Feb 18 '17 at 23:43
no it timed out – Jack Frye Feb 18 '17 at 23:45
Can you connect using the `mysql` commands from your localhost? https://dev.mysql.com/doc/refman/5.7/en/connecting.html – djthoms Feb 18 '17 at 23:45
so it's not a driver issue but network one – vladkras Feb 18 '17 at 23:45
i would assume i would need to install mysql locally? would it use the same binaries on windows/be able to communicate? – Jack Frye Feb 18 '17 at 23:46
did you try http://stackoverflow.com/a/2985169/1713660 – vladkras Feb 19 '17 at 00:04
yeah, answer is quoted from my second source – Jack Frye Feb 19 '17 at 00:05

Cannot Connect to Port 3306 MySql Server on Centos from Windows

0 Answers0