python 批量监测数据库是否正常（mysql）

输入ip，端口，用户名，密码 批量监测数据库是否正常

并且当某一个数据库崩溃都返回一个0

import pymysql

# 输入str
str1 = [('192.168.200.200', 5100, 'root', 'root'),
        ('192.168.200.260', 5100, 'root', 'root'),
        ]


def mysql_check(host, port, user, password):
    # 数据库测定值
    mysqlbool = None
    # -----数据库链接-----
    try:
        connect = pymysql.connect(
            host=host,
            port=port,
            user=user,
            password=password,
            charset='utf8',
        )
        # 查询语句
        print(connect)
        sql = "SELECT 1;"
        cursor = connect.cursor()
        cursor.execute(sql)
        results = cursor.fetchall()
        # 关闭游标与链接
        cursor.close()
        connect.close()
        print(host,"数据库正常")
        mysqlbool = 1
    except:
        print(host,"数据库不正常")
        mysqlbool = 0
    return mysqlbool


def mysql_checkjudge(mysql):
    mysqlbooltemp = 1
    print(mysql)

    for i in mysql:
        host = i[0]
        port = i[1]
        user = i[2]
        password = i[3]
        mysqlbool = mysql_check(host, port, user, password)
        mysqlbool = (mysqlbooltemp and mysqlbool)
        mysqlbooltemp = mysqlbool

    return mysqlbool


mysql_checkjudge(str1)