Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
09-19-2005, 02:38 PM
|
#1
|
LQ Newbie
Registered: Sep 2005
Posts: 7
Rep:
|
mysqld running and reading for connections on port 3306, no port 3306 found from scan
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
|
|
|
09-20-2005, 07:56 AM
|
#2
|
Member
Registered: Jun 2005
Location: q3dm7
Distribution: Mandriva 2010.0 x86_64
Posts: 338
Rep:
|
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)
Last edited by Snowbat; 09-20-2005 at 07:58 AM.
|
|
|
09-20-2005, 09:34 AM
|
#3
|
LQ Newbie
Registered: Sep 2005
Posts: 7
Original Poster
Rep:
|
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.
|
|
|
09-20-2005, 10:11 AM
|
#4
|
Member
Registered: Jun 2005
Location: q3dm7
Distribution: Mandriva 2010.0 x86_64
Posts: 338
Rep:
|
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
Last edited by Snowbat; 09-20-2005 at 10:13 AM.
|
|
|
09-20-2005, 11:49 AM
|
#5
|
LQ Newbie
Registered: Sep 2005
Posts: 7
Original Poster
Rep:
|
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
|
|
|
09-20-2005, 05:01 PM
|
#6
|
LQ Newbie
Registered: Sep 2005
Posts: 7
Original Poster
Rep:
|
I finally got it. Thanks snowbat for your help =D
|
|
|
09-20-2005, 09:35 PM
|
#7
|
Member
Registered: Jun 2005
Location: q3dm7
Distribution: Mandriva 2010.0 x86_64
Posts: 338
Rep:
|
No worries. What was it (as a matter of interest and for the next person who has a similar problem)?
|
|
|
09-21-2005, 10:10 AM
|
#8
|
LQ Newbie
Registered: Sep 2005
Posts: 7
Original Poster
Rep:
|
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.
|
|
|
07-13-2016, 10:54 AM
|
#9
|
Member
Registered: Dec 2015
Posts: 46
Rep: 
|
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
|
|
|
07-13-2016, 11:51 AM
|
#10
|
Member
Registered: Dec 2015
Posts: 46
Rep: 
|
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
|
|
|
07-13-2016, 11:53 AM
|
#11
|
Member
Registered: Dec 2015
Posts: 46
Rep: 
|
Quote:
Originally Posted by Snowbat
|
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
|
|
|
All times are GMT -5. The time now is 11:15 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|