Best answer

MySQL requires VPN login for security

  • 20 March 2020
  • 3 replies
  • 6514 views

Userlevel 1

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? 

icon

Best answer by PaulKortman 20 March 2020, 20:47

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

 

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 1

OR, I could open 3306 just for Zapier’s IP address. What IP address does Zapier use to connect to my database?

Userlevel 7
Badge +9

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

 

Userlevel 1

Opening the port to Zapier’s IP did the trick. Thank you!