#! /bin/bash
 
 cat nowcoder.txt | grep "ESTABLISHED" | grep "3306" | awk '{print $(NF-1)}' | awk -F ":" '{print $1}' |
 sort | uniq -c | sort -nk 1 -r | awk '{print $1" "$2}'