Level 80
@szaboanna01 Databases are added to Heroku apps as “add-ons”. Once you’ve provisioned an add-on, it will show up under the Resources tab in your app’s details, where you can also get that database’s credentials.
Apr 8, 2022
7
Level 1
How to connect to a Heroku database via HeidiSQL or MySQL Workbench?
I am working on a project that I host on Heroku. I have a JawsDB database in the background, and I would like to connect to it and add some records to the tables using HeidiSQL or MySQL Workbench, but I can't connect to the server even though I type the correct hostname/username/password. Is it poosible to solve this problem?
Level 1
@martinbean I entered these credentials but it didn't worked, unfortunately.
Level 80
@szaboanna01 Then you entered them incorrectly.
Level 1
@martinbean I checked them many times, but it didn't worked. :(
Level 80
@szaboanna01 I don’t know what to tell you? If you can’t connect then you’re using invalid credentials.
I’ve used Heroku for years and have never had any issues connecting to databases attached to my app after going to my app’s resources and grabbing the credentials from databases.
Level 1
@martinbean It's working now. I accidently added an unnecessary character to the password, and that's why it didn't worked.. Thanks!
Level 80
@szaboanna01 No problem. Glad you found the problem 🙂
Please or to participate in this conversation.