# Netstat -an output question

**URL:** <https://forums.percona.com/t/netstat-an-output-question/272>\
**Category:** Other MySQL® Questions\
**Created:** [April 6, 2007, 8:16pm UTC](https://forums.percona.com/t/netstat-an-output-question/272 "2007-04-06T20:16:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mysqluser81](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@mysqluser81](https://forums.percona.com/u/mysqluser81)\
**Post date:** [April 6, 2007, 8:16pm UTC](https://forums.percona.com/t/netstat-an-output-question/272/1 "2007-04-06T20:16:07Z")

</div>

Hello I was wondering if someone could please explain shed some light as to why I see the stuff below when starting mysql.

netstat -an |grep :3306

what does all that stuff mean and why some many connection between local system?

thanks for the help!! )

tcp 0 0 ::ffff:127.0.0.1:56556 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56557 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56635 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56634 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56639 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56638 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56637 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56636 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56626 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56631 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56619 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56618 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56617 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56616 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56622 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56611 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56610 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56609 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56608 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56615 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56614 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56613 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56612 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56603 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56602 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56601 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56600 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56607 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56606 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56605 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56604 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56599 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56598 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56597 ::ffff:127.0.0.1:3306 ESTABLISHED  
tcp 0 0 ::ffff:127.0.0.1:56587 ::ffff:127.0.0.1:3306 ESTABLISHED

---

<div class="post-metadata">

**Author:** ![joemasters](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@joemasters](https://forums.percona.com/u/joemasters)\
**Post date:** [April 7, 2007, 5:38am UTC](https://forums.percona.com/t/netstat-an-output-question/272/2 "2007-04-07T05:38:16Z")

</div>

It looks like you have local connections through tcp/ip to mysql. Can you use the socket file (unix/linux) or named pipes/shared memory (windows)?

The mysql reference guide shows how to specify different connect strings to use different protocols on the machine running mysql server – basically, if you reference the ip, it’ll use tcp/ip.
