Having a problem with Bitdefender Firewall and mysql 3306 port
I am trying to access a sql remote database to run a query. The query code is correct and has been reviewed
However, after a long wait, I am getting the following response (excerpts are below):
TimeoutError: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\User\PycharmProjects\Project1\newapp.py", line 8, in <module>
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'X' (10060 A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond)
Someone involved with the database, had a look at this and told me:
"!I just now test-connected to the remote server and it was fine for me. So the problem is surely that your connection is being blocked.
Maybe by a firewall app on your computer. If so, then please google this:
firewall mysql 3306 port"
I have Bitdefender Total Security, the latest version. Please could you let me know how to allow the 3306 port so I can access the remote SQL database.
Thanks for your help