# cat clouddb | grep cloud | while read host; do echo $host; mysql.py -h$host mysql -e "select user,host from user where user like '%haproxy%';";done clouddb1013:3311 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1013:3313 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1014:3312 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1014:3317 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1015:3314 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1015:3316 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1016:3315 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1016:3318 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1017:3311 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1017:3313 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1018:3312 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1018:3317 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1019:3314 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1019:3316 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1020:3315 User Host haproxy 10.64.37.27 haproxy 10.64.37.28 clouddb1020:3318 User Host haproxy 10.64.37.27 haproxy 10.64.37.28