# In the LAN can know how many computers installed MySQL via software or command line
**URL:** https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925
**Category:** Other MySQL® Questions
**Created:** [September 6, 2013, 3:11am UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925 "2013-09-06T03:11:09Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@dongtrien](https://forums.percona.com/u/dongtrien)
#### Post date: [September 6, 2013, 3:11am UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/1 "2013-09-06T03:11:09Z")
[LEFT]
---
### Author:  [@przemek](https://forums.percona.com/u/przemek)
#### Post date: [September 6, 2013, 4:06am UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/2 "2013-09-06T04:06:40Z")
There are many network discovery tools out there that you can use. My favourite one is [nmap](http://nmap.org/). For example to list all computers with MySQL running (TCP port 3306 open) in one subnet:
```auto
nmap -sT -p3306 --open 10.1.0.0/24
```
Of course you will not see hosts that are firewalled.
---
### Author:  [@dongtrien](https://forums.percona.com/u/dongtrien)
#### Post date: [September 9, 2013, 9:53pm UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/3 "2013-09-09T21:53:03Z")
I using OS MicroSoft WindowsXP, Could you told me detail ?
---
### Author:  [@przemek](https://forums.percona.com/u/przemek)
#### Post date: [September 10, 2013, 4:41am UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/4 "2013-09-10T04:41:17Z")
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. [url][http://nmap.org/download.html[/url]](http://nmap.org/download.html%5B/url%5D)
---
### Author:  [@dongtrien](https://forums.percona.com/u/dongtrien)
#### Post date: [September 10, 2013, 9:12pm UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/5 "2013-09-10T21:12:38Z")
I see the website [url][http://nmap.org/download.html[/url]](http://nmap.org/download.html%5B/url%5D) 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.
---
### Author:  [@przemek](https://forums.percona.com/u/przemek)
#### Post date: [September 11, 2013, 4:58am UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/6 "2013-09-11T04:58:30Z")
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.
---
### Author:  [@dongtrien](https://forums.percona.com/u/dongtrien)
#### Post date: [September 15, 2013, 10:13pm UTC](https://forums.percona.com/t/in-the-lan-can-know-how-many-computers-installed-mysql-via-software-or-command-line/2925/7 "2013-09-15T22:13:35Z")
I’ve tried it but do not be