Not the answer you need?
Register and ask your own question!

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

dongtriendongtrien EntrantCurrent User Role Beginner

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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:
    nmap -sT -p3306 --open 10.1.0.0/24
    

    Of course you will not see hosts that are firewalled.
  • dongtriendongtrien Entrant Current User Role Beginner
    I using OS MicroSoft WindowsXP, Could you told me detail ?
  • przemekprzemek Percona Support Engineer Percona Staff Role
    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
  • dongtriendongtrien Entrant Current User Role Beginner
    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.
  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
  • dongtriendongtrien Entrant Current User Role Beginner
    I've tried it but do not be
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.