capture_host_port.go

db, err := sql.Open("mysql", user+":"+password+"@tcp("+host+":3306)/information_schema")
if err != nil {
  log.Fatal(err)
}
defer db.Close()

hostWithPort := getHost(db)
if hostWithPort == nil {
  log.Println("Could not find query with that ID")
  return
}
hostAndPort := strings.Split(hostWithPort, ":")
host, port := hostAndPort[0], hostAndPort[1]

log.Printf("Host: %s  Port: %s\n", host, port)

func getHost(db *sql.DB) string {
	result, err := db.Query("select HOST from processlist where ID = ?", *pid)
	if err != nil {
		log.Panic(err)
	}

	defer result.Close()

	var host string
	for result.Next() {
		result.Scan(&host)
	}

	return host
}