Unable to connect to JawsDB instance on Heroku

user_1530072 0
Viewed 2556

I just created a JawsDB MySQL instance and provisioned it with my app. Performing a heroku config: get JAWSDB_URL yields the following string:

mysql://(redacted-username):(redacted-password)@h40lg7qyub2umdvb.cbetxkdyhwsb.us-east-1.rds.amazonaws.com:3306/schema

When attempting to connect to this database using any database manager GUI, such as MySQL Workbench or HeidiSQL using the following parameters:

| Key        | Value               |
| ---------- | ------------------- |
| hostname   | h40lg7qyub2umdvb.cbetxkdyhwsb.us-east-1.rds.amazonaws.com |
| port       | 3306                |
| username   | (redacted-username) |
| password   | (redacted-password) |
| connection | TCP/IP              |

...I receive the following error:

Failed to Connect to MySQL at h40lg7qyub2umdvb.cbetxkdyhwsb.us-east-1.rds.amazonaws.com:3306 with user (redacted-username)

Lost connection to MySQL server at 'reading initial communication packet', system error: 0

This is my second attempt at trying this - I received the same error with the JawsDB instance I just set up earlier, so I deleted that and receive the same error again here. Any ideas?

heroku mysql
1 Answers

After further investigation, I found out that port 3306 was blocked at my University, no thanks to the unhelpful error message.

Hopefully this helps others who encounter this problem, as this isn't in the docs.

user_15300720
Related