mysql数据库连接测试代码

import pymysql

# 建立数据库连接
def connect_to_mysql():
    try:
        conn = pymysql.connect(
            host='localhost',  # MySQL服务器地址
            port=3306,         # MySQL服务器端口号，默认为3306
            user='root',       # MySQL用户名
            password='123456', # MySQL密码
            database='test'    # 需要连接的数据库名称
        )
        print("MySQL数据库连接成功！")
        return conn
    except Exception as e:
        print("MySQL数据库连接失败：", e)
        return None

# 执行查询语句
def execute_query(conn):
    try:
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM table_name")  # 替换为实际的查询语句
        results = cursor.fetchall()
        for row in results:
            # 处理查询结果
            pass
        cursor.close()
        conn.close()
        print("查询执行成功！")
    except Exception as e:
        print("查询执行失败：", e)

# 测试数据库连接
conn = connect_to_mysql()
if conn:
    execute_query(conn)