Not able to connect to SSL enable Azure MySql using python script.

Question

Not able to connect to SSL enable Azure MySql using python script.

Mahendra Rajgude 0

not able to connect to SSL enable Azure MySql using python script.

Getting following error in Python

mysql.connector.errors.InterfaceError: 2055: Lost connection to MySQL server at 'gcm-daas-backup-srv.mysql.database.azure.com:3306', system error: 1 [SSL: NO_CIPHERS_AVAILABLE] no ciphers available (_ssl.c:1002)

Any help / pointer will appreciated.

Mahendra

Sai Raghunadh M 4,500 Reputation points Microsoft External Staff Moderator

2025-03-14T09:34:21.69+00:00

Mahendra Rajgude

Just checking in to see if the below answer provided by @Amira Bedhiafi helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

2 answers

Your answer

Sai Raghunadh M 4,500 Reputation points Microsoft External Staff Moderator

2025-03-14T09:34:21.69+00:00

Mahendra Rajgude

Just checking in to see if the below answer provided by @Amira Bedhiafi helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Mahendra Rajgude 0

Thanks for help.

Basically , our problem got solved after uninstalling and installing sql packages in python, clearing cache and deleting temp files.

Thanks for your help.

0 comments

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more