while read server port; do out=$(sudo -i mysql.py --connect-timeout=5 -BN -h $server -P $port -e "show databases like 'test'; show databases like 'test\\_%'"); [ -n "$out" ] && { echo "$server $port" $out; }; done < instances

db1075.eqiad.wmnet 3306 test
db1078.eqiad.wmnet 3306 test
db1079.eqiad.wmnet 3306 test
db1081.eqiad.wmnet 3306 test
db1083.eqiad.wmnet 3306 test
db1084.eqiad.wmnet 3306 test
db1085.eqiad.wmnet 3306 test
db1086.eqiad.wmnet 3306 test
db1088.eqiad.wmnet 3306 test
db1089.eqiad.wmnet 3306 test
db1090.eqiad.wmnet 3317 test
db1091.eqiad.wmnet 3306 test
db1093.eqiad.wmnet 3306 test
db1094.eqiad.wmnet 3306 test
db1095.eqiad.wmnet 3313 test
db1096.eqiad.wmnet 3315 test
db1096.eqiad.wmnet 3316 test
db1098.eqiad.wmnet 3316 test
db1098.eqiad.wmnet 3317 test
db1099.eqiad.wmnet 3311 test
db1100.eqiad.wmnet 3306 test
db1101.eqiad.wmnet 3317 test
db1112.eqiad.wmnet 3306 test
db1113.eqiad.wmnet 3316 test
db1116.eqiad.wmnet 3317 test
db1117.eqiad.wmnet 3325 test_labsdbaccounts
db1120.eqiad.wmnet 3306 test
db1121.eqiad.wmnet 3306 test
db1123.eqiad.wmnet 3306 test
db1127.eqiad.wmnet 3306 test
db1130.eqiad.wmnet 3306 test
db1131.eqiad.wmnet 3306 test
db1133.eqiad.wmnet 3306 test_labsdbaccounts
db1134.eqiad.wmnet 3306 test
db1135.eqiad.wmnet 3306 test
db1136.eqiad.wmnet 3306 test
db1138.eqiad.wmnet 3306 test
db1141.eqiad.wmnet 3306 test
db1144.eqiad.wmnet 3314 test
db1144.eqiad.wmnet 3315 test
db1145.eqiad.wmnet 3314 test
db1145.eqiad.wmnet 3315 test
db1148.eqiad.wmnet 3306 test
db1149.eqiad.wmnet 3306 test
db2073.codfw.wmnet 3306 test
db2074.codfw.wmnet 3306 test
db2076.codfw.wmnet 3306 test
db2077.codfw.wmnet 3306 test
db2078.codfw.wmnet 3325 test_labsdbaccounts
db2085.codfw.wmnet 3311 test
db2086.codfw.wmnet 3317 test
db2087.codfw.wmnet 3316 test
db2087.codfw.wmnet 3317 test
db2088.codfw.wmnet 3311 test
db2089.codfw.wmnet 3316 test
db2090.codfw.wmnet 3306 test
db2092.codfw.wmnet 3306 test
db2093.codfw.wmnet 3306 test test_labswiki
db2114.codfw.wmnet 3306 test
db2118.codfw.wmnet 3306 test
db2120.codfw.wmnet 3306 test
db2121.codfw.wmnet 3306 test
db2122.codfw.wmnet 3306 test
db2135.codfw.wmnet 3306 test_labsdbaccounts
db2136.codfw.wmnet 3306 test
dbstore1003.eqiad.wmnet 3311 test
dbstore1003.eqiad.wmnet 3317 test
dbstore1004.eqiad.wmnet 3313 test
dbstore1004.eqiad.wmnet 3314 test
es1011.eqiad.wmnet 3306 test
es1013.eqiad.wmnet 3306 test
es1014.eqiad.wmnet 3306 test
es1017.eqiad.wmnet 3306 test
es2017.codfw.wmnet 3306 test
es2018.codfw.wmnet 3306 test
es2019.codfw.wmnet 3306 test
pc1008.eqiad.wmnet 3306 test