SSL connection error to MySQL with Python 3.7. InterfaceError: SSL connection error: Failed to set ciphers to use

Question

I am new to MySQL and I have recently set up a server for learning and testing purposes. The end goal is to be able to connect to MySQL using ODBC for other computers and with a Python connector from the local computer. I tried to set up the basic connection to MySQL in python with the following code:

import mysql.connector

myDb = mysql.connector.connect(
             host ='localhost',
             user ='username',
             password = 'password');

print(myDb);

But I get the following error message:

InterfaceError: SSL connection error: Failed to set ciphers to use.

There are no SSL certificates created or configured in MySQL, but it keeps giving me this response.

Maria Varga · Accepted Answer · 2019-07-04 18:39:57Z

7

try adding flag 'use_pure' :

db_connection = mysql.connector.connect(host='127.0.0.1', user='root', password='password123',use_pure=True)

answered Jul 4, 2019 at 18:39

Maria Varga

711 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSL connection error to MySQL with Python 3.7. InterfaceError: SSL connection error: Failed to set ciphers to use

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related