LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 09-19-2005, 02:38 PM   #1
darkenigmaa
LQ Newbie
 
Registered: Sep 2005
Posts: 7

Rep: Reputation: 0
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
 
Old 09-20-2005, 07:56 AM   #2
Snowbat
Member
 
Registered: Jun 2005
Location: q3dm7
Distribution: Mandriva 2010.0 x86_64
Posts: 338

Rep: Reputation: 30
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.
 
Old 09-20-2005, 09:34 AM   #3
darkenigmaa
LQ Newbie
 
Registered: Sep 2005
Posts: 7

Original Poster
Rep: Reputation: 0
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.
 
Old 09-20-2005, 10:11 AM   #4
Snowbat
Member
 
Registered: Jun 2005
Location: q3dm7
Distribution: Mandriva 2010.0 x86_64
Posts: 338

Rep: Reputation: 30
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.
 
Old 09-20-2005, 11:49 AM   #5
darkenigmaa
LQ Newbie
 
Registered: Sep 2005
Posts: 7

Original Poster
Rep: Reputation: 0
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
 
Old 09-20-2005, 05:01 PM   #6
darkenigmaa
LQ Newbie
 
Registered: Sep 2005
Posts: 7

Original Poster
Rep: Reputation: 0
I finally got it. Thanks snowbat for your help =D
 
Old 09-20-2005, 09:35 PM   #7
Snowbat
Member
 
Registered: Jun 2005
Location: q3dm7
Distribution: Mandriva 2010.0 x86_64
Posts: 338

Rep: Reputation: 30
No worries. What was it (as a matter of interest and for the next person who has a similar problem)?
 
Old 09-21-2005, 10:10 AM   #8
darkenigmaa
LQ Newbie
 
Registered: Sep 2005
Posts: 7

Original Poster
Rep: Reputation: 0
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL not listening on port 3306 mr_sarge Linux - Newbie 14 12-03-2013 04:17 AM
How do I allow mysql connections over network (netstat -an | grep 3306 produces nil)? jdruin Linux - Software 6 04-03-2013 10:35 AM
Using serial port card(PCMCIA) with IPAQ running Linux, can't find ttyS0 port d2army Linux - Laptop and Netbook 0 11-12-2005 08:07 PM
mysql 3306 security sopiaz57 Linux - Security 8 03-07-2004 04:32 PM
mysql port 3306 bulliver Linux - Security 4 04-17-2003 08:00 PM


All times are GMT -5. The time now is 11:38 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration