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
MySQL requires VPN login for security
- Beginner
Best answer by PaulKortman
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 54.86.9.50 (This is only for Database connections like MySQL.
I found that and below here.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
- Beginner
OR, I could open 3306 just for Zapier’s IP address. What IP address does Zapier use to connect to my database?
+10- Zapier Solution Partner
- Answer
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 54.86.9.50 (This is only for Database connections like MySQL.
I found that and below here.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.