I am trying to connect to a remote database using Python and ‘mysql-connector’ but am getting error ‘Can’t connect to MySQL server’. I am also getting a timeout error when attempting to connect to the database using psql.
I know that the remote database is working as I’m able to connect to it from my local computer on my network, which is whitelisted.
I attempted to whitelist the “myservice-onrender.com” domain as well as the IP returned from a dns query on this domain, with no luck in connecting to the remote database. Is there a step that I’m missing?