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

Question

从自制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

Answer 2

conn=mysql.connector.connect(host = "localhost", user = "root", passwd = "password",use_pure=True)
print(conn)
if(conn):
    print("Connection successful")
else:
    print("Connection unsuccessful")