LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-04-2012, 02:15 AM   #1
Shahid nx
Member
 
Registered: Jan 2012
Posts: 46

Rep: Reputation: Disabled
Which server is running mysql?


Hi All,
In our office we have so many servers . Among these some servers are running mysql. i m facing problem to find in which all the servers mysql is running. Sir/Friends is there any method to find this. Plz help me out. (I m working in linux platform)

Regards,
SHAHID NX
 
Old 06-04-2012, 03:40 AM   #2
fukawi1
Member
 
Registered: Apr 2009
Location: Melbourne
Distribution: Fedora & CentOS
Posts: 854

Rep: Reputation: 190Reputation: 190
I would suggest using nmap.
Something along the lines of
Code:
nmap -p 3306 --open -sV 10.0.0.0/24 > mysqlservers
Where 10.0.0.0/24 would be replaced with the subnet you wish to scan.
This will scan all hosts on the specified subnet look for the mysql port to be open..
This is not going to be 100%, firewalls and such could break it easily...

Some other ideas to get you started.
Using ssh to remotely execute ps and/or netstat -tnlp to look for the mysql process or if mysql is listenning on port 3306.

If the traffic to/from the mysql servers is being routed, you could use tcpdump to sniff out the ip addresses sending packets on 3306.

I really have to say that I am astounded that you are in this situation, your network should be documented so you (and anybody else) always know what is where.
 
  


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
LXer: Running Multiple MySQL Server Instances in Parallel on a Linux Server LXer Syndicated Linux News 0 10-11-2010 01:00 PM
Joomla does not see MYSQL server, yet its installed and running? lortech Linux - General 3 11-17-2009 10:29 AM
to check whether mysql server is running vinaytp Linux - Newbie 3 04-27-2009 07:19 AM
connecting to mySQL server running on FC5 dessonville50 Fedora 4 05-09-2006 07:00 AM
probs running MYSQL-SERVER on debian bennethos Debian 4 10-30-2004 09:10 AM


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

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration