Announcement

Announcement Module
Collapse
No announcement yet.

In the LAN can know how many computers installed MySQL via software or command line

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • In the LAN can know how many computers installed MySQL via software or command line

    In a LAN with multiple computers, a few machines installed MySQL you can use the script in cmd.exe (or any software) to know how many LAN computers are not installed MySQL ?

  • #2
    There are many network discovery tools out there that you can use. My favourite one is nmap. For example to list all computers with MySQL running (TCP port 3306 open) in one subnet:
    Code:
    nmap -sT -p3306 --open 10.1.0.0/24
    Of course you will not see hosts that are firewalled.

    Comment


    • #3
      I using OS MicroSoft WindowsXP, Could you told me detail ?

      Comment


      • #4
        Have you visited the nmap website? There is also version for Windows. You can also install zenmap - graphical interface which may be easier for you. http://nmap.org/download.html

        Comment


        • #5
          I see the website http://nmap.org/download.html and download nmap-6.40-setup.exe to install the machine, I tried to run Nmap software - Zenmap GUI but does not scan any computer in the network LAN have got MySQL installed. while my network LAN with several computers installed MySQL.

          Comment


          • #6
            So the question is if the host from you are trying to scan the network is allowed to access those computers. Are you able to connect to those MySQL servers from that host with normal mysql client? If yes, then you seems to be not using nmap correctly. Also you may try to add "-P0" paramater to nmap command if only ICMP packets are blocked.
            Maybe those MySQL servers are only listening on local IP addresses? Check for bind_address in your mysql configs.
            Last edited by przemek; 09-11-2013, 06:33 AM.

            Comment


            • #7
              I've tried it but do not be

              Comment

              Working...
              X