Trouble Connecting SQL Database Connector to MySQL Server

Hello everyone,

I have a problem similar to what others have discussed in this forum, but I haven’t been able to find a solution yet. Here’s my issue:

I’m attempting to connect my self-hosted MySQL database to Bubble using the SQL Database Connector. Here’s the connection string I’m using:

mysql://user:password@16.170.221.159:3306/db_name

However, I keep receiving the following error:
“Connection issue: SQL Database Connector issue: Connection attempt failed: SQL Database Connector issue”

After researching similar topics, I’ve ruled out firewall restrictions as I’ve ensured that the IP address of the database is open to all external IPs. I’ve also considered URL-encoding the password for proper connection, but that didn’t resolve the issue either.

I’m currently on the free plan for Bubble. Could anyone provide me some suggestions on what else I could check?

Thanks in advance for any assistance!

Anyone that can help?

Try https://www.phpmyadminonline.com/ to connect to your DB. If you can connect, it might be a bubble mysql configuration issue. If you cant connect through that, probably it is your DB issue. Anyway, it will help you to localize the problem at least.

Hi Hergin,

Thank you for the advice. I was able to connect, which means it is a bubble mysql configuration issue.
What I am trying to do is pretty basic, so I don’t understand why the plug in is not working.

Can you share your bubble mysql config screenshot? (with your password hidden ofcourse)

Sure:

bubble is both the username and also the name of the database:
WhatsApp Image 2024-05-05 at 19.10.52

So you have a database called bubble? Because the last part of the URL is not user name, it is the database name. You should create the database yourself in the server.

Yes, it called bubble. Do you think this might be a problem that is called like the username?
WhatsApp Image 2024-05-05 at 19.15.27

I don’t think so. But it worth trying :slight_smile:

Also, maybe create an empty bubble app (for test) and add mysql in there so you made sure your current app is not broken in some way.

tried both but still not working…