#!/bin/bash

awk '/ESTABLISHED/{
    if($5~/:3306$/){
        h=substr($5,1,index($5,":")-1);
        a[h]++
    }
}END{
    for(i in a){
        printf "%s %s\n",a[i],i
    }
}' | sort -rn