Errno 111 connection refused python mysql

Is mysql.database.azure.com blocked from access?

Hi ,

I trying to run sql from my python script but hit below error: Is it due to azure.com block?

    Traceback (most recent call last):
      File "/usr/local/lib/python3.9/site-packages/mysql/connector/network.py", line 607, in open_connection
        self.sock.connect(sockaddr)
    ConnectionRefusedError: [Errno 111] Connection refused


During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/home/okl/ibox_wkly_svs_lvl", line 7, in <module>
    mydb = connection.connect(host="xxxxxxxxx.mysql.database.azure.com", database = 'xxxxx',user="xxxxxxx@xxxxxxxemysql", passwd="xxxxxx",use_pure=True)
  File "/usr/local/lib/python3.9/site-packages/mysql/connector/__init__.py", line 271, in connect
    return MySQLConnection(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/mysql/connector/connection.py", line 107, in __init__
    self.connect(**kwargs)
  File "/usr/local/lib/python3.9/site-packages/mysql/connector/abstracts.py", line 985, in connect
    self._open_connection()
  File "/usr/local/lib/python3.9/site-packages/mysql/connector/connection.py", line 308, in _open_connection
    self._socket.open_connection()
  File "/usr/local/lib/python3.9/site-packages/mysql/connector/network.py", line 609, in open_connection
    raise errors.InterfaceError(
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'depotboxcaremysql.mysql.database.azure.com:3306' (111 Connection refused)

Thanks]

okl | 11 posts | Oct. 24, 2021, 12:23 p.m. | permalink

I've added .mysql.database.azure.com to the whitelist. Try again.

Hi

Not working , could it be you need the whole address?

"depotboxcaremysql.mysql.database.azure.com"

okl | 11 posts | Oct. 24, 2021, 1:15 p.m. | permalink

Sorry, I just realized that it would not work for the free account as it is not http connection, so the whitelist is not relevant.