Python My SQL connection

Jack Brien 0

Hello,

Hoping someone can help me with a connection issue. I'm trying to connect a python script to a mysql database using the mysql.connector library, but it keeps throwing an error. (2003 (HY000): Can't connect to MySQL server on 'example.database.windows.net:3306' (10060))

I've got the host set to (server name swapped out for "example") "example.database.windows.net", and have also tried "example.mysql.database.windows.net", neither of which work, and neither of which can I resolve with DNS using my ISP, 8.8.8.8 or 1.1.1.1.

When I have eventually found a DNS record for this (51.105.72.32), this IP is not pingable.

Please can someone correct my syntax or point me in the direction of how to fix this?

Thanks,

Jack

GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2023-05-16T19:36:44.0533333+00:00

Hi @Jack Brien Welcome to the Microsoft Q&A forum, Thanks for posting your question.

Can you please share your Python code snippet so I can better assist you?

Regards

Geetha
Konstantinos Passadis 17,286 Reputation points

2023-05-17T11:15:31.7066667+00:00

Hello @Jack Brien!

Do you have any feedback or is your issue resolved?

In case any answer helped kindly mark it as Accepted and upvote so others can benefit as well!

Regards
Konstantinos Passadis 17,286 Reputation points

2023-05-17T17:01:41.1266667+00:00

Hello @Jack Brien!

Do you have any feedback or is your issue resolved?

In case any answer helped kindly mark it as Accepted and upvote so others can benefit as well!

Regards

2 answers

Konstantinos Passadis 17,286 Reputation points

2023-05-16T18:47:37.1166667+00:00

Hello @Jack Brien!

Welcome to Microsoft QnA!

I understand you want to connect from your Local PC to Azure MySql

First of all avoid exposing IPs and Credentials , try somehting like XX.XX.XX.XX, not everyone has the best intentions!

Please go to Azure Portal and add your IP address to the allowed list :

If you are on Public Hotspot make a try to add all nets and see if you can connect

If you cannot , there is a chance your Outbound Access i restricted in 3306

MySQL is not Pingable btw

Check also this :

In case SSL is set to required you need to follow these

https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-configure-ssl

So you can get the Certificate

Please go carefully through the Docs!

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards
Please sign in to rate this answer.
Konstantinos Passadis 17,286 Reputation points

2023-05-16T19:36:52.61+00:00

Hello @Jack Brien!

Also Download the correct Certificate :

And here s the sample Python Code

import mysql.connector from mysql.connector import Error # replace the placeholders with your actual details cnx = mysql.connector.connect( user="x", password="xxxxxxx", host="xxxxxxxxxx.mysql.database.azure.com", port=3306, database="xxxxxxxxxxx", ssl_ca="C:\\Users\\user\\Downloads\\DigiCertGlobalRootCA.crt (1).pem", ssl_disabled=False ) try: if cnx.is_connected(): db_Info = cnx.get_server_info() print("Connected to MySQL Server version ", db_Info) cursor = cnx.cursor() cursor.execute("select database();") record = cursor.fetchone() print("You're connected to database: ", record) except Error as e: print("Error while connecting to MySQL", e) finally: if (cnx.is_connected()): cursor.close() cnx.close() print("MySQL connection is closed")

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Konstantinos Passadis 17,286 Reputation points

2023-05-16T20:19:40.4766667+00:00

Hello @Jack Brien!

Did you manage to connect ?

I forgot to tell you this that in my ISP it is a common issue :

When i open a Service in Azure and have the ability to insert my IP into the firewall , so directly adds my Ip to allowed , the detection could be something else from the IP i get using "Whats My IP Site"

So thats why i suggest to open the whole 0.0.0.-255.255.255.255 just for a minute or two and check if you get prompt

If you do and then remove the 0.0.0.0-255.255.255.255 firewall entry and cannot connect , then Azure has identified an IP of A.A.A.A but your pragmatic IP could be B.B.B.B so add BOTH into the firewall rules!

Just a hint that you may face or facing !

I hope input helped

Please dont forget to set any Answer that helped as Accepted and Up Vote ,so others can find this helpful!

Regards
Sign in to comment
GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2023-05-18T22:52:17.9733333+00:00

@Jack Brien Here are the clear steps you can follow https://stackoverflow.com/questions/39461850/connecting-to-azure-sql-with-python

If you are still facing the issue please provide more details to better assist you.

Regards

Geetha
Please sign in to rate this answer.
GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2023-05-30T14:01:50.7866667+00:00

@Jack Brien Following up to see if the issue is resolved.
Sign in to comment