Hello! I’m using an AWS RDS MySQL database because eventually I need to make parts of my app HIPAA compliant. While I can access my test database through MySQL Workbench, I’m unable to connect using the Bubble SQL Database Connector plugin, although my connection string follows the protocol, as fol…

The end of my connection string is 3306/db_name while yours is 3306:db_name Maybe that’s the issue.

Thank you very much, joeyg, for your help. I mistyped my example in this post, did use 3306/db_name. I have a lead I’m following up. I realized that my AWS db does not have a name, only the db instance has a name…which I used the db instance name both as part of the end point (my-db-instance), and …

Have the solution, connected now! The db_name at the end of the connection string needs to be the schema name that I set up using MySQL workbench, within the AWS db instance.

Thanks for posting this solution. I tried a few more options based on this. However, after trying the instance name and the schema name, still stuck. Both result in the same error: ‘Connection issue: SQL Database Connector issue: Connection attempt failed: connect ETIMEDOUT’ Sounds like we may w…

I get the timeout error too. It’s a cryptic bit of documentation for getting PostgreSQL connection string. Very little helpful information and to be honest, should be much easier to set up Bubble! Host, port, username, password, endpoint fields exist in every other platform. Get to it!

Making the database public doesn’t seem to be a popular idea, it isn’t my call there. I would have tried it then watched for what IP showed up. However, I found out that it can change unless you have dedicated hosting. Bubble support got back to me with some suggestions including whitelisting by IP…

Did you also create your schema in your database? That’s the one thing I haven’t tried yet, was just connecting to the database name at the end of the connection string, so it would be something like this: postgresql://database:password@awsdbname.awsid.us-east-2.rds.amazonaws.com:PORT/schema To be…

I tried the schema name and database name. The IP is blocked, I have to wait on them to work on it. Even before getting this plugin going, I am wondering about limitations. I may program in a lot of queries as well and wondering about management. For example, if you could just reorder them for grou…

@mc3digital What you are saying about the public IP is true. It’s not the best idea from a security practice standpoint however it is the only way unless you move to a dedicated cluster on Bubble. As for limitations the Pro plugin we built offer flexiblity to be able to store your queries in a tabl…

Unable to connect to AWS RDS MySQL with SQL Database Connector Plugin

Need help Plugins

ben13 February 22, 2023, 4:20pm 7

@mc3digital you definitely want to make sure you can set the server as publicly availabe since you won’t have a specific origin IP address you can reliably connect from.

External Mysql Error SQL Database Connector

SQL Connector Plug-in timing out

Topic		Replies	Views
Connector problem Database	1	1006	November 9, 2016
I want to connect Bubble and AWS RDS Plugins	0	121	November 30, 2024
How to connect to a mysql database hosted on EC2 APIs	2	1219	April 27, 2022
External Mysql Error SQL Database Connector Database	3	443	March 23, 2023
[New Feature] Database connector New features	34	24712	July 14, 2022

Unable to connect to AWS RDS MySQL with SQL Database Connector Plugin

Related topics