# Trouble Connecting SQL Database Connector to MySQL Server

**URL:** <https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814>\
**Category:** Database\
**Created:** [May 4, 2024, 10:09am UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814 "2024-05-04T10:09:47Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![umbi](https://avatars.discourse-cdn.com/v4/letter/u/d6d6ee/32.png) [@umbi](https://forum.bubble.io/u/umbi)\
**Post date:** [May 4, 2024, 10:09am UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/1 "2024-05-04T10:09:47Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![umbi](https://avatars.discourse-cdn.com/v4/letter/u/d6d6ee/32.png) [@umbi](https://forum.bubble.io/u/umbi)\
**Post date:** [May 4, 2024, 5:16pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/2 "2024-05-04T17:16:48Z")

</div>

Anyone that can help?

---

<div class="post-metadata">

**Author:** ![hergin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/hergin/32/199185_2.png) [@hergin](https://forum.bubble.io/u/hergin)\
**Post date:** [May 5, 2024, 3:41pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/3 "2024-05-05T15:41:15Z")

</div>

Try [https://www.phpmyadminonline.com/](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.

---

<div class="post-metadata">

**Author:** ![umbi](https://avatars.discourse-cdn.com/v4/letter/u/d6d6ee/32.png) [@umbi](https://forum.bubble.io/u/umbi)\
**Post date:** [May 5, 2024, 5:04pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/4 "2024-05-05T17:04:25Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![hergin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/hergin/32/199185_2.png) [@hergin](https://forum.bubble.io/u/hergin)\
**Post date:** [May 5, 2024, 5:06pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/5 "2024-05-05T17:06:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![umbi](https://avatars.discourse-cdn.com/v4/letter/u/d6d6ee/32.png) [@umbi](https://forum.bubble.io/u/umbi)\
**Post date:** [May 5, 2024, 5:11pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/6 "2024-05-05T17:11:44Z")

</div>

Sure:

 ![Capture](https://us1.discourse-cdn.com/bubble/original/3X/8/8/88ecba7b4f81b1bb8ef5ff8a324d859163957282.png)

bubble is both the username and also the name of the database:  
 ![WhatsApp Image 2024-05-05 at 19.10.52](https://us1.discourse-cdn.com/bubble/original/3X/c/4/c469cca0f677b61cc688205d1e83d13c65a8cfe3.jpeg)

---

<div class="post-metadata">

**Author:** ![hergin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/hergin/32/199185_2.png) [@hergin](https://forum.bubble.io/u/hergin)\
**Post date:** [May 5, 2024, 5:12pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/7 "2024-05-05T17:12:40Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![umbi](https://avatars.discourse-cdn.com/v4/letter/u/d6d6ee/32.png) [@umbi](https://forum.bubble.io/u/umbi)\
**Post date:** [May 5, 2024, 5:16pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/8 "2024-05-05T17:16:58Z")

</div>

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](https://us1.discourse-cdn.com/bubble/original/3X/6/9/69e8b18f8d7ee4a2e73c1ee7cf916f7e50a940a1.jpeg)

---

<div class="post-metadata">

**Author:** ![hergin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/hergin/32/199185_2.png) [@hergin](https://forum.bubble.io/u/hergin)\
**Post date:** [May 5, 2024, 5:23pm UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/9 "2024-05-05T17:23:17Z")

</div>

> [@umbi](#):
>
> Do you think this might be a problem that is called like the username?

I don’t think so. But it worth trying 🙂

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.

---

<div class="post-metadata">

**Author:** ![umbi](https://avatars.discourse-cdn.com/v4/letter/u/d6d6ee/32.png) [@umbi](https://forum.bubble.io/u/umbi)\
**Post date:** [May 6, 2024, 9:38am UTC](https://forum.bubble.io/t/trouble-connecting-sql-database-connector-to-mysql-server/320814/10 "2024-05-06T09:38:30Z")

</div>

tried both but still not working…
