Forums

Add Python Anywhere MYSQL database to Google Data Studio

Hi,

I would like to add a Python AnyWhere MYSQL database as a source on Google Data Studio but I dont seem to be able to. When checking the help page on Google, there seems to be a list of IP to whitelist : https://support.google.com/datastudio/answer/7088031?hl=en&ref_topic=7332343 Is it possible to whitelist them for my account ?

Thank you

deleted-user-2626447 | 3 posts | July 31, 2018, 1:16 p.m. | permalink

Due to security constraints, you cannot easily access your MySQL database externally. See this for the only way to access it.

Staff conrad | 4232 posts | PythonAnywhere staff | July 31, 2018, 3:57 p.m. | permalink

I am trying to do the same thing, was this ever able to be resolved?

deleted-user-5576865 | 3 posts | May 26, 2019, 8:33 p.m. | permalink

See the documentation that conrad linked to. The IP of your MySQL server may change without warning, so whitelisting an IP is not a stable option.

Staff glenn | 9718 posts | PythonAnywhere staff | May 27, 2019, 10:45 a.m. | permalink

I am also trying to connect Google Data Studio to my MySQL DB on Python Anywhere. They don't seem to offer an SSH connection but they do offer SSL. Is there any way to use that technology to create a connection? Thank you, Ben

deleted-user-1392216 | 14 posts | Sept. 9, 2019, 12:37 a.m. | permalink

This is just a scam to make you have to get a paid account lol

dull | 758 posts | Sept. 9, 2019, 2:50 a.m. | permalink

There's no way using SSL directly, unfortunately :-(

Staff giles | 12087 posts | PythonAnywhere staff | Sept. 9, 2019, 11:14 a.m. | permalink

@giles Thank you

@dull I already have a paid account. Actually, the costs seem quite reasonable compared to the alternatives.

deleted-user-1392216 | 14 posts | Sept. 9, 2019, 12:30 p.m. | permalink