Mysql.connector.errors.interfaceerror: 2026 (hy000)

After switching from homebrew python to anaconda python, code that worked previously, now gets the following error: mysql.connector.errors.InterfaceError: 2026 (HY000): SSL connec

Solution 1:

I guess that mysql connector in anaconda is having some compatibility issues with openssl. The solution is to downgrade openssl.

conda install openssl=1.0.2p

See this thread for more information:

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

Solution 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")