Looker Studio MySQL connector cannot connect to Cloudways-hosted MySQL database

Looker Q&A Looker Studio
1

Hello,

I’m trying to connect a Cloudways-hosted MySQL database to Google Looker Studio using the native MySQL connector, but the connection fails.

I’ve confirmed:

  • Correct database credentials

  • Host = server public IP

  • Port = 3306

  • SSL disabled

  • Remote MySQL access enabled

I’ve also whitelisted the following Google IP ranges in
Cloudways → Server Management → Security → MySQL:

64.18.0.0/20
64.233.160.0/19
66.102.0.0/20
72.14.192.0/18
74.125.0.0/16
108.177.8.0/21
172.217.0.0/19

However, Looker Studio still returns the error:

“Sorry, we encountered an error and were unable to complete your request.”
Error ID: 91279f19

Is there a specific IP range, SSL requirement, or known limitation when connecting Looker Studio to a Cloudways-hosted MySQL database?

Thanks in advance.