Azianese
Azianese

Reputation: 624

MySQL Workbench Cannot Connect to Database Server (Heroku, JawsDB)

My workbench was previously working fine until recently, but I'm now getting the following error:

enter image description here

I'm not sure what's relevant so I'll list out everything that I think might be relevant:

I'm not sure what else might be the issue here. Thanks in advance.

Edit: After trying to connect to the MySQL server through the command line, I get "ERROR 2003 (HY000): Can't connect to MySQL server on 'lyl3nln24eqcxxot.cbetxkdyhwsb.us-east-1.rds.amazonaws.com' (10060)", which seems to be an authentication error and not a connection error according to this link. But I'm unsure how to deal with this authentication error if it is one.

Upvotes: 2

Views: 1331

Answers (2)

ibot
ibot

Reputation: 1

I had the same issue, but i later realized that the max connection for jawsdb is 10 for the user on a free tier. You can solve this by implementing a connection manager like Hikari and limit the max connection to 7 so you have available connections when using workbench.

Upvotes: 0

Azianese
Azianese

Reputation: 624

I'm not sure if this constitutes as an answer, but I've managed to establish a connection through my usual wifi (as opposed to a public school's wifi). It looks like either my security settings are different when on a public wifi or the public wifi itself had some sort of security setting that was blocking my connection.

Upvotes: 0

Related Questions