How to access remote MySql database? "Host 'ec2-x-xx-xxx-xxx.compute-1.amazonaws.com' is not allowed to connect to this MariaDB server". What IP address I should set to the privileged user, so I can access it from web service?

[nikola sofronovic]

 

[Daniel Mikusa]

There are no static IP addresses for outgoing traffic from applications running on PWS. Even if there were, it would not be safe to whitelist them because outbound traffic from all apps running on a Cell would appear to come from the same IP.

 

https://community.pivotal.io/s/article/The-original-IP-addresses-for-the-requests-made-by-the-run-pivotal-io-CF-applications

 

There are services which can allow you to do this though. QuotaGuard is one.

 

https://docs.run.pivotal.io/marketplace/services/quotaguard.html