foo=( $(grep password  data.txt) )
for i in "${foo[@]}"
do

echo "$i" | sed 's/Failed//g' | sed "s/ip//g" | sed "s/for//g" | sed "s/from//g" | sed "s/port//g" | sed "s/user//g" | sed '/^$/d'
done
DB_USER='****';
DB_PASSWD='*******';
DB_NAME='test';
TABLE='store';
mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME <<EOF
INSERT INTO $TABLE (`ip`, `port`) VALUES ( );
EOF

output of echo command :-

Mar 4 03:08:16  124.55.124.22 1254
Mar 4 03:08:16  132.66.465.82 1161
Mar 4 03:08:16  111.96.924.62 1364