mysql 登入脚本

import mysql.connector

def connect_to_mysql():
    try:
        connection = mysql.connector.connect(
            host="your_host",
            user="your_user",
            password="your_password",
            database="your_database"
        )
        print("Connected to MySQL successfully!")
        return connection
    except mysql.connector.Error as err:
        print(f"Error: {err}")
        return None

def execute_query(connection, query):
    cursor = connection.cursor()
    try:
        cursor.execute(query)
        result = cursor.fetchall()
        for row in result:
            print(row)
    except mysql.connector.Error as err:
        print(f"Query execution failed: {err}")

if __name__ == "__main__":
    connection = connect_to_mysql()
    if connection:
        execute_query(connection, "SELECT * FROM your_table")
        connection.close()