Connection to a mySQL DB via google apps script

[hpiyankov]

Hello,

I am trying to connect to a DB located in box6 via google apps scripts. From what I read so far, I need to add a host/IP that can access the DB, but how am I supposed to do this in the given case? I should ask google what IP are they using to make SQL requests?

Thanks in advance.

[Modestas]

Hello,

Box6 IP address is 94.249.139.3.

[hpiyankov]

Thanks, but I think you misunderstood my question.

As far as I read so far, I need to explicitly specify which EXTERNAL IPs will be accessing my DB (which is situated on box6). However, the requests will be made from a google apps script application (which runs on google servers). So my question is : how can I authorize such access to the DB?

[Modestas]

You can try to add access host for database by going to MySQL Management and clicking on your database.

[hpiyankov]

One additional question... is there a way to add a range of IP addresses that can access the db?

It turns out my script has to access the DB from one of the following ranges:

216.239.32.0 - 216.239.63.255
64.233.160.0 - 64.233.191.255
66.249.80.0 - 66.249.95.255
72.14.192.0 - 72.14.255.255
209.85.128.0 - 209.85.255.255
66.102.0.0 - 66.102.15.255
74.125.0.0 - 74.125.255.255
64.18.0.0 - 64.18.15.255
207.126.144.0 - 207.126.159.255
173.194.0.0 - 173.194.255.255

Is there a way to add them as ranges?