python连接mySQL

安装 mysql-connector-python 库

pip install mysql-connector-python

完整代码

connMysql.py

import mysql.connector

# 配置数据库连接参数
config = {
    'user': '********',    # 你的MySQL用户名
    'password': '**********', # 你的MySQL密码
    'host': '**********',         # MySQL服务器地址，本地为localhost
    'database': '******', # 需要连接的数据库名
    'raise_on_warnings': True
}

try:
    # 建立数据库连接
    connection = mysql.connector.connect(**config)
    if connection.is_connected():
        db_info = connection.get_server_info()
        print("成功连接到MySQL数据库，版本为：", db_info)
        
        # 创建一个游标对象，用于执行SQL语句
        cursor = connection.cursor()

        # 插入数据
        cursor.execute("""
            INSERT INTO cti_ai_chat_logs (initiator, content)
            VALUES ('John Doe', '11111111111111111111')
        """)
        
        # 提交事务
        connection.commit()
        
        # 查询数据
        cursor.execute("SELECT * FROM cti_ai_chat_logs")
        for row in cursor:
            print(row)
        
        # 关闭游标
        cursor.close()
        
        # 关闭数据库连接
        connection.close()
        
except mysql.connector.Error as err:
    print("发生错误：", err)
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL连接已关闭")