Whitelist ip range for SQL access (CIDR)

[Lucas.]

Hi!

I would like to add a range (CIDR) of IP addresses so Google Looker Studio can read my SQL database.
I tried adding 74.125.0.0/16 but it seems this is not accepted. Is there another way to add this in bulk?

Adding one by one is no option since there are to many

 

[Richard G]

I would like to add a range (CIDR) of IP addresses

Exactly where to you want to add this? To the csf.ignore? Or where?

Also I just did some Google search and encountered this page:

Connect to MySQL - Looker Studio Help

Connect Looker Studio to MySQL databases.The MySQL connector allows you to access data from MySQL databases within Looker Studio. In this article: How to connect to MySQL

support.google.com

But they mention other ip ranges:

IP addresses​

• 142.251.74.0/23
  
  
• 2001:4860:4807::/48 (Optional, for platforms that support IPv6)

 

[Lucas.]

I need Google Looker studio to be able to access MySQL so I yes to the CSF.ignore.
I had this article with updated ip's of 2023:

Connect to MySQL - Looker Studio Help

Connect Looker Studio to MySQL databases.The MySQL connector allows you to access data from MySQL databases within Looker Studio. In this article: How to connect to MySQL

support.google.com

 

[Lucas.]

Hm, okay. I just double checked, and this range 142.251.74.0/23 is already in my csf.allow.
But I still can't seem to access my database trough Google Looker Studio

 

[Lucas.]

So, I just managed to access my MYSQL Database trough looker after adding the IP to my SQL settings as following: 142.251.74.%