I am trying to connect a Google Docs extension to a MySQL database via JDBC Service. For that, I have to whitelist the IP addresses as per https://developers.google.com/apps-script/guides/jdbc#setup_for_other_databases
How can I do this quickly using CPanel, since there are a few hundreds of them?
One by one seems like an awful work to do......
This was a HUGE issue for me. This was my solution.
64.18.0-15.%
64.233.160-191.%
64.102.0-15.%
66.249.80-95.%
72.14.192-255.%
74.125.%
173.194.%
207.126.144-159.%
209.85.128-255.%
216.239.32-63.%
Yes, Right you will have to add that IP range in allow host list though cPanel >> Mysql >> Remote Mysql
As per my knowledge, 192.168.0.128-255
this one adds IP from 192.168.0.128 to 192.168.0.255
. So try giving it as 192.168.0.128-15.255
.
Also for 64.233.160.0 - 64.233.191.255
, you could try giving it as 64.233.160.0-191.255
.
Hope that helps!