我在用mysql-connector-python给Flask应用连接MySQL数据库的时候，遇到了个头疼的问题：脚本直接挂起不动了。MySQL服务器肯定是正常运行的——我在VSCode里能完美连接上它，但通过命令行就死活连不上。

我尝试过的方法 #

• 确认MySQL服务器处于运行状态
• 安装了mysql-connector-python（当前版本是9.2.0）
• 给连接设置了超时参数

我明明已经给连接尝试加了超时限制，为什么脚本还是会挂住？有没有人能帮我看看该怎么解决这个问题？

我的连接测试代码 #

print("Starting database connection test...")

import mysql.connector
import os
from dotenv import load_dotenv

load_dotenv(r"C:\Users\Skip\Documents\personal-projects-github\hairsalon-flask-web-app\.env")

print("Environment variables loaded.")

db_config = {
    "host": os.getenv("DB_HOST", "localhost"), 
    "user": os.getenv("DB_USER", "root"),       
    "password": os.getenv("DB_PASSWORD", ""),  
    "database": os.getenv("DB_NAME", "salon"), 
    "port": int(os.getenv("DB_PORT", "3306")), 
    "auth_plugin": "mysql_native_password",
}

print("Attempting to connect to the database...")
print("Database configuration:", db_config)

try:
    print("Connecting to MySQL...")
    conn = mysql.connector.connect(**db_config)
    print("Connected to MySQL database!")
    conn.close()
except Exception as e:
    print("Error connecting to MySQL:", e)

补充：运行输出示例 #

C:\Users\Skip\Documents\personal-projects-github\hairsalon-flask-web-app>python tests\sql-connector_test.py
Starting database connection test...
Environment variables loaded.
Attempting to connect to the database...
Database configuration: {'host': 'localhost', 'user': 'root', 'password': '####', 'database': 'salon', 'port': 3306, 'auth_plugin': 'mysql_native_password'}
Connecting to MySQL...

C:\Users\Skip\Documents\personal-projects-github\hairsalon-flask-web-app>

备注：内容来源于stack exchange，提问作者Inez Anne-Marie