mysql.connector.errors.InterfaceError : 2026 (HY000)

Question

从 homebrew python 切换到 anaconda python 后，之前可以正常工作的代码现在出现以下错误:

mysql.connector.errors.InterfaceError: 2026 (HY000): SSL connection error: SSL_CTX_set_tmp_dh failed

这是我的代码:

import mysql.connector

mydb = mysql.connector.connect(
  host = "localhost",
  user = "root",
  passwd = "123456root",
  database = "tourists"
)

mycursor = mydb.cursor()

#mycursor.execute("CREATE DATABASE tourists")

#mycursor.execute("CREATE TABLE clients(id INT NOT NULL AUTO_INCREMENT                PRIMARY KEY,firstname VARCHAR(255), lastname VARCHAR(225), year VARCHAR(5),   room VARCHAR(2))")

mycursor.execute("ALTER TABLE clients ADD COLUMN telefon")

mycursor.execute("ALTER TABLE clients ADD COLUMN parere")

mycursor.execute("ALTER TABLE clients ADD COLUMN localitate"

Answer 1

我猜想 anaconda 中的 mysql 连接器与 openssl 存在一些兼容性问题。解决办法是降级openssl。

conda install openssl=1.0.2p

请参阅此主题以获取更多信息:

https://github.com/ContinuumIO/anaconda-issues/issues/10646