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?
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.
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.
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.