Not being able to connect with MySQL

Looker Q&A Looker Studio
,
1

Hello guys,

So we have MySQL DB on a VPC on Germany. We have contacted the admins in order to allow requests from the IP range of google as per docs: 142.251.74.0/23, however, when I try to connect on Looker Studio, I get the following error:

Sorry, we encountered an error and were unable to complete your request.
Error ID: 454d173e

The error ID changes on each iteration, and have not found help by searching by it, got no useful feedback from the platform.

What I have debugged so far is:

  1. MySQL User: I am using the same user locally so the MySQL user is not the issue
  2. Connection With CA Certificate: I am using my ca.pem locally to connect through the proxy and I am being able to connect successfully
  3. Google IP Range: I have created a tcp tunnel from my local with ngrok in order to connect from Looker and see the IP from which they did it. And found it is between the range that we allowed on the Load Balancer on the production MySQL servers. As I am not in same region of the MySQL production servers, might it be that Google is using other IPs there?

These is all I have been able to see for know, would appreciate any help. Thanks.