SQL Database Connection Error

Need help
1

I’m trying to add a MySQL DB hosted on the cloud. I’ve read the whole bubble manual and did everything as it says.

For my case, the DB link goes as follows:

mysql://bubble:[url_encoded_password]@[hosted_db_instance_ip_address]:[port]/[db_name]

test 2
test 2760×168 6.92 KB

Every time I tried, it says this error:

Connection issue: SQL Database Connector issue: Connection attempt failed: SQL Database Connector issue

I had a few whitelisted IP addresses in the cloud instance firewall, which I removed after a bit of research and hope for a change, but alas! nothing changed. It still showed the error.

I also tried replacing the instance IP address with the “Instance_name,“ i.e., my-db-instance.endpoint.us-east-1.rds.amazonaws.com. But that didn’t make a difference either.

My username, password, and IP address or instance_name are accurate and double-checked, but the error persists.

2

I used to help solve issues with the SQL Connector, possibly one of the past replies is useful …

https://forum.bubble.io/search?q=%40mishav%20sql

FWIW due to multiple issues, most people that I know of who were trying to use the SQL Connector did not implement in their production app, instead going for an API-based access.

3

@mishav Unfortunately, whitelisting the bubble app IPs in cloud SQL is the core way, yet the error continues.

As mentioned in my OP i did try with both zone and IP connection additionally, to understand my error, but Bubble SQL connection doesn’t explain what is causing the error, unlike API connector.

@mishav and are you referring to Cloud SQL Admin API when you say connection via API ?