import pymysql

# Ganti dengan hostname dari cPanel Anda
HOSTNAMES_TO_TRY = [
    'sql.pipinip1.org',
    'mysql.pipinip1.org', 
    'pipinip1.org',
    'localhost',
]

USER = 'pipinip1_org'
PASSWORD = 'Raihanw05'
DATABASE = 'pipinip1_blog'

print("=" * 60)
print("MENCARI HOSTNAME YANG BENAR")
print("=" * 60)

for host in HOSTNAMES_TO_TRY:
    try:
        print(f"\nMencoba host: {host}")
        conn = pymysql.connect(
            host=host,
            user=USER,
            password=PASSWORD,
            database=DATABASE,
            port=3306,
            connect_timeout=5
        )
        print(f"✅ BERHASIL! Hostname yang benar: {host}")
        
        with conn.cursor() as cursor:
            cursor.execute("SELECT COUNT(*) as total FROM users")
            result = cursor.fetchone()
            print(f"✅ Total users: {result[0]}")
            
        conn.close()
        print(f"\n🎉 Gunakan DB_HOST={host} di .env")
        break
        
    except Exception as e:
        print(f"❌ Gagal: {str(e)[:50]}...")