SQL Connector - Connection string for google cloud simplified

Need help
1

Hello

I am using the Google cloud and want to connect MySQL database with bubble well lost solving the “connection string”.

If any could help me get the string or explain for the connection parameter in a simple way.

thank you in advance.

2

Bubble’s documentation gives sample connection strings. What have you tried and what error do you get?

3

Yes i checked it out and tried couple of step… being a non-coder … not happening anything.

:password@my-db-instance.endpoint.us-east-1.rds.amazonaws.com:PORT/db_name”

I got my Google sql username:password
SQL i.p
my-db-instance.endpoint (east-asia)
Port: (couldn’t find it)/
have the database make

the above is for rds if you could suggest for google

thank you

4

Are you prepared to learn some of the SQL language?

What does this mean?

When putting special codes in this forum, highlight them and press the button that looks like </> to show them properly, for example:

mysql://username:password@my-db-instance.endpoint.us-east-1.rds.amazonaws.com:PORT/db_name

The default port for MySQL is 3306, try this first if you aren’t given a specific one.
If the password has any weird characters it might need to be url-encoded.
If there are any firewall restrictions you’ll need to configure google cloud to allow Bubble’s servers to connect.

mysql://username:password@hostname:3306/dbname

I couldn’t work out from your post what is hostname or dbname.

2 Likes
5

@mishav

These are what I could get from google sql console

  1. sql user - user:password
  2. Primary IP address - 35.236.137.100
  3. Instance connection name - myappdb-217508:asia-east1:myappdb-google
  4. Service account details
  5. Restrictions are off.

So any suggestion or gudiance with the details

yes going through some contents online to learn sql.

thank you

6

Try these combinations …

mysql://username:password@35.236.137.100:3306/myappdb-google
mysql://username:password@35.236.137.100:3306/myappdb-217508
mysql://username:password@35.236.137.100:3306/myappdb

7

Thank you @mishav the combinations did try to connect… but not work. Well may be try the api for google storage.

8

This topic was automatically closed after 70 days. New replies are no longer allowed.