A way to disable SSL using python MySQLdb connector

Question

Opening a connection using SSL with python connector gives me following error:

MySQLdb.connect(host='host',user='user,passwd='xxx',db='xxx',)

OperationalError: (2026, 'SSL connection error: ASN: unknown key OID type')

The same is when I am using bash mysql command:

mysql -p -u user -h host
Enter password:
ERROR 2026 (HY000): SSL connection error: ASN: unknown key OID type

The only way around I have found was to use --ssl-mode=DISABLED

mysql -p -u user -h host --ssl-mode=DISABLED
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.

Is there any way I am able to mimic this using python connector? I am using mysql v 5.7.26 on Ubuntu 16.04 and python 3.5.2.

For the future generations, the issue was solved by changing the connector to the one from mysql-connector-python. It's function mysql.connector.connect has kwarg ssl_disabled = True. — silvermat
– silvermat, Commented Jun 26, 2019 at 2:47

ralfr · Accepted Answer · 2019-12-30 22:46:43Z

9

Connect to mysql/mariaDB without SSL in python:

import mysql.connector
from mysql.connector import Error

mysql_config = {
        'user': 'DB-user',
        'password': 'userpassword',
        'host': 'localhost',
        'database': 'your-DB-name',
        'port': '3306',
        'ssl_disabled': True
    }

try:
    cnx = mysql.connector.connect(**mysql_config)
    if cnx.is_connected():
        print('connected to database') 

except Error as e:
    print("mysql DB connection error")
    print(e)

Also see full documentation: Mysql Connector/Python Connection Arguments.

If you want to connect via mysqlx, see examples on Getting started with mysqlx.

edited Dec 30, 2019 at 22:46

answered Dec 30, 2019 at 22:39

ralfr

1661 silver badge7 bronze badges

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

2 Comments

majkrzak Over a year ago

I'm getting AttributeError: Unsupported argument 'ssl_disabled' error

Unmitigated Over a year ago

@majkrzak Might be the issue mentioned in this answer.

Constantine Kurbatov · Accepted Answer · 2022-12-26 04:37:36Z

4

As the original poster mentioned in his comment, one of the most convenient ways to disable SSL in Python — is by using pip install mysql-connector-python and then employing the ssl_disabled key.

mysql.connect(host=HOST, database=DATABASE, port=PORT, user=USER, password=PASSWORD, ssl_disabled=True/False)

So the code would look like this:

    import mysql.connector as mysql
    
    db_connection = mysql.connect(host=HOST, database=DATABASE, port=PORT, user=USER, password=PASSWORD, ssl_disabled=True)
    print("Connected to:", db_connection.get_server_info())
    db_handler = connection.cursor()
    db_handler.execute("SELECT * FROM your_table")
    fetch_result = db_handler.fetchall()
    for item in fetch_result:
        print(item)

edited Dec 26, 2022 at 4:37

answered Mar 17, 2021 at 15:02

Constantine Kurbatov

93515 silver badges16 bronze badges

Comments

willnode · Accepted Answer · 2024-01-10 09:36:00Z

1

For those who get AttributeError: Unsupported argument 'ssl_disabled', do this:

pip uninstall mysql-python
pip install mysql-connector-python

python-mysql is a legacy client version, with latest version released in 2014.

answered Jan 10, 2024 at 9:36

willnode

1,54716 silver badges21 bronze badges

Comments

julio_sao · Accepted Answer · 2020-07-13 14:24:17Z

0

According to manual, "ssl" key manages, if present, the ssl protocol. So I supose passing a void dictionary on this tag, may work for you. (Works in may Try this:

mysql_config = {
        'user': 'DB-user',
        'password': 'userpassword',
        'host': 'localhost',
        'database': 'your-DB-name',
        'port': '3306',
        'ssl': {}
    }
self.connection = MySQLdb.connect(**mysql_config )
self.connection.autocommit(True)
return database.DBOK

answered Jul 13, 2020 at 14:24

julio_sao

11

1 Comment

Roberto Caboni Over a year ago

I just want to report you a typo, in case you want to fix it: the sentence "(Works in may Try this:" sounds some way truncated.

arno_v · Accepted Answer · 2022-03-22 07:49:39Z

0

Note that mysqlclient also supports the ssl_mode param since version 2.0.0. With that you can also do:

MySQLdb.connect(host='host', user='user', passwd='xxx', db='xxx', ssl_mode='DISABLED')

answered Mar 22, 2022 at 7:49

arno_v

20.8k4 gold badges34 silver badges37 bronze badges

Collectives™ on Stack Overflow

A way to disable SSL using python MySQLdb connector

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related