查看mysql服务3306端口连接个数

mysqladmin -u root -p status | grep Threads

netstat -an | grep 3306 | wc -l

netstat -an | find "3306" | find /c "LISTENING"

SHOW STATUS LIKE 'Threads_connected';

import mysql.connector

def get_mysql_connection_count():
    try:
        conn = mysql.connector.connect(user='root', password='your_password', host='localhost', database='mysql')
        cursor = conn.cursor()
        cursor.execute("SHOW STATUS LIKE 'Threads_connected'")
        result = cursor.fetchone()
        cursor.close()
        conn.close()
        return int(result[1])
    except Exception as e:
        print(f"Error: {e}")
        return None

if __name__ == "__main__":
    count = get_mysql_connection_count()
    if count is not None:
        print(f"Current MySQL 3306 port connection count: {count}")