Mysql Tricks : Monitor port 3306

  Monitor port 3306:

        tcpdump  -i eth0 -nN -vvv -xX  -s 1500  port 3306 and host not 192.168.1.102

      The -s is length of each packet. This monitors all traffic on port 3306 excluding
      the good client 192.168.1.102.  The out will be in the following format:

[root@third-fl-71 root]# tcpdump  -i eth0 -nN -vvv -xX  -s 1500  port 3306 and host not 192.168.1.102
tcpdump: listening on eth0
13:05:01.857705 192.168.1.103.4131 > 192.168.1.71.mysql: S [tcp sum ok] 2542149285:2542149285(0) win 16384 <mss 1460,nop,nop,sackO
0x0000   4500 0030 0b39 4000 8006 6b90 c0a8 0167        E..0.9@...k....g
0x0010   c0a8 0147 1023 0cea 9786 1ea5 0000 0000        ...G.#..........
0x0020   7002 4000 ebe7 0000 0204 05b4 0101 0402        p.@.............
13:05:04.863552 192.168.1.103.4131 > 192.168.1.71.mysql: S [tcp sum ok] 2542149285:2542149285(0) win 16384 <mss 1460,nop,nop,sackO

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image