Error while connecting to MySQL Database

[Rishab2]

https://lookerstudio.google.com/getAccountTree

API is failing with 503 Service Unavailable error. Please help

Below is the API response:

{"reason":24,"errorStatus":{"reason":24,"code":14,"reasonStr":"JDBC_CONNECTION_ERROR","errorCategoryStr":"DATASET_CONFIGURATION","category":5,"uniqueErrorCode":"46263929"},"params":{"errorId":"46263929"}}

[mpskovvang]

I've experienced the same error and finally managed to solve the issue.

In my case, the reason was the MySQL instance using the caching_sha2_password authentication plugin, which requires a secure connection.

I used Cloud SQL Studio to authenticate the MySQL user, and afterwards, the connection works in Looker Studio due to some caching.

Probably only a temporary workaround.