mysqld running and reading for connections on port 3306, no port 3306 found from scan

darkenigmaa · 09-19-2005, 03:38 PM

I'm trien to connect to mysql server remotely. my.cnf file has #skip networking commented out. but when I have mysqld server running. it says its ready for connections through socket..., port =3306. but when i try a port scan for this nothing comes up. why is this? i know i cant remote connect to it if the port doesnt show up with a port scan. what do i have to change for settings to allow this to happen.

Darkenigma

Snowbat · 09-20-2005, 08:56 AM

From a shell on the server can you telnet to port 3306? Did you pinhole port 3306 in the server's firewall? If you're behind a NAT router, have you port forwarded 3306 to this box?

# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost (127.0.0.1).
Escape character is '^]'.
.
4.0.11a-gamma▒|p<wet8Y
(The connection times out after a few seconds of no input)

darkenigmaa · 09-20-2005, 10:34 AM

When i telnet localhost 3306 i get this:

#telnet localhost 3306
trying 127.0.0.1....
telnet: connect to address 127.0.0.1: connection refused

I have the servers firewall disabled, because the server itself is behind a firewall with port 3306 open.

Snowbat · 09-20-2005, 11:11 AM

mysqld is running?:
ps -A | grep mysqld

You've set a root password and you can use the mysql command to create a database?
http://www.yolinux.com/TUTORIALS/Lin...rialMySQL.html

darkenigmaa · 09-20-2005, 12:49 PM

yes mysqld is running and i can log on to it locally and create databases. But only locally. I need to be able to connect to it remotely

darkenigmaa · 09-20-2005, 06:01 PM

I finally got it. Thanks snowbat for your help =D

Snowbat · 09-20-2005, 10:35 PM

No worries. What was it (as a matter of interest and for the next person who has a similar problem)?

darkenigmaa · 09-21-2005, 11:10 AM

My internal fire was disabled, but not bypassed. Had to take it completely out i think it was /etc/SuSEfirewall112. it was also causeing ping problems aswell. so once i found that out it lead me in the right direction.

linuxnewbie0101 · 07-13-2016, 11:54 AM

Quote:

Originally Posted by darkenigmaa

My internal fire was disabled, but not bypassed. Had to take it completely out i think it was /etc/SuSEfirewall112. it was also causeing ping problems aswell. so once i found that out it lead me in the right direction.

So i am having similar issues,

i've installed mysql 5.5.49 on ubuntu trusty, this is in my dev environment, i am able to telnet it from dev environment machines. however, when try to connect from my production environment (precise), i am getting

telnet: Unable to connect to remote host: Connection timed out

how did you get this resolved?

Thank you

linuxnewbie0101 · 07-13-2016, 12:51 PM

Quote:

Originally Posted by Snowbat

From a shell on the server can you telnet to port 3306? Did you pinhole port 3306 in the server's firewall? If you're behind a NAT router, have you port forwarded 3306 to this box?

# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost (127.0.0.1).
Escape character is '^]'.
.
4.0.11a-gamma▒|p<wet8Y
(The connection times out after a few seconds of no input)

this is telnet from my dev mysqltest server that i recently setup

Code:

fangj@mysqltest:~$ telnet localhost 3306
Trying ::1...
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
_
5.5.49-0ubuntu0.14.04.1-logMTGFgW\J�.plN}NLpqf+Amysql_native_password

linuxnewbie0101 · 07-13-2016, 12:53 PM

Quote:

Originally Posted by Snowbat

mysqld is running?:
ps -A | grep mysqld

You've set a root password and you can use the mysql command to create a database?
http://www.yolinux.com/TUTORIALS/Lin...rialMySQL.html

mysqld is running

Code:

fangj@mysqltest:~$ ps -A | grep mysql
32063 pts/0    00:00:00 mysqld_safe
32424 pts/0    00:00:02 mysqld