My database server is not accessible to the public, port 3306 is closed via the firewall for security reasons. But I can still connect after I VPN into my hosting company and use a private IP to connect to MySQL. Is it possible for Zapier to connect to a VPN then use the private IP?
Best answer by PaulKortmanView original
OR, I could open 3306 just for Zapier’s IP address. What IP address does Zapier use to connect to my database?
unfortunately, it’s not possible for Zapier to run over a VPN tunnel. So yes, to enable this to work you will have to allow traffic over port 3306 for an IP Address. And you’re not alone in this. the IP address you will need to allow is 220.127.116.11 (This is only for Database connections like MySQL.
I found that and below here.
Opening the port to Zapier’s IP did the trick. Thank you!