#!/bin/bash

grep 'ESTABLISHED' nowcoder.txt | awk '/^tcp/ {print $(NF-1)}' | grep -E ':3306$' | awk -F ':' '{ip[$1]++} END {for (i in ip) print ip[i] " " i}' | sort -k1rn