python 使用 mysql.connector 连接数据库

在 Python 中安装 mysql.connector 库，您可以使用 pip 包管理器进行安装。如果您的系统上已安装了 pip，请在命令行/终端中执行以下命令：

pip3 install mysql-connector-python -i https://mirrors.aliyun.com/pypi/simple

安装完成后，您可以在 Python 代码中导入 mysql.connector 模块并使用它来连接到 MySQL 数据库。
例如：

import sys
import mysql.connector
# pip3 install mysql-connector-python -i https://mirrors.aliyun.com/pypi/simple
class MySQLConnector:
    def __init__(self, user, password, host, port, database):
        self.user = user
        self.password = password
        self.host = host
        self.database = database
        self.port = port
        self.cnx = None
    def connect(self):
        try:
            self.cnx = mysql.connector.connect(
                user=self.user, password=self.password, host=self.host, database=self.database, port=self.port)
            print("Successfully connected to MySQL database!")
            return True
        except mysql.connector.Error as err:
            print("Failed to connect to MySQL database: {}".format(err))
            return False
    def close(self):
        if self.cnx:
            self.cnx.close()
            print("Connection to MySQL database is closed.")
if __name__ == '__main__':
    # 禁止生成 __pycache__
    sys.dont_write_bytecode = True
    connector = MySQLConnector(
        user='root', password='your_password', host='your_host', port=3306, database='your_database')
    if connector.connect():
        connector.close()