MySQL Forums
Forum List  »  MySQL Administrator

Could not open connection to the host, on port 3306
Posted by: Campbell Dean
Date: January 22, 2014 01:33PM

I am trying to telnet from my laptop (W7 x64) to my Linux (Centos) server using port 3306 and it's just not letting me. Im using a laptop and a Linux machine (x86) both on my home network 192.168.0.x via a router.


The full error I get from Windows-7 laptop cmd window is:

Connecting To 192.168.0.5...Could not open connection to the host, on port 3306:
Connect failed

I've done hours of research on this, and have tried practically everything and am at a loss. I can use port 80 ok.

These are the things I've tried:
- using port 80 (worked fine)
- ping 192.168.0.5 (worked fine)
- ssh to root@192.168.0.5 (worked fine)
- I run Kaspersky firewall on my laptop (Windows 7 x64) and have opened ports 3306 across TCP & UDP protocols

I've changed the iptables on Linux and it is listening to port 3306 as far as I know; I used linux command: netstat -an | grep 3306 and it returned a line with information containing "tcp" and "LISTEN" as well as "192.168.0.5:3306" (the IP address being the linux server - ie itself)

the mysqld daemon is running (it's ALWAYS running!)

Please someone help - ask me all questions, hopefully I can answer them ;)



Edited 1 time(s). Last edit at 01/22/2014 01:53PM by Campbell Dean.

Options: ReplyQuote


Subject
Written By
Posted
Could not open connection to the host, on port 3306
January 22, 2014 01:33PM
January 24, 2014 11:44AM


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.