云访问局域网数据库服务器

import mysql.connector
from mysql.connector import Error

def connect_to_database():
    try:
        connection = mysql.connector.connect(
            host='192.168.1.100',  # 本地局域网内数据库服务器IP
            user='username',
            password='password',
            database='database_name'
        )
        if connection.is_connected():
            print("Connected to MySQL database")
            cursor = connection.cursor()
            cursor.execute("SELECT * FROM table_name")
            records = cursor.fetchall()
            for row in records:
                print(row)
    except Error as e:
        print(f"Error while connecting to MySQL: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()
            print("MySQL connection is closed")

if __name__ == "__main__":
    connect_to_database()