I wanted to manage the database from an offline/desktop app.
I’m not being able to connect to the database from home. Is there a way to make such connection?
Yes, you can do this, and this wiki article explains how to do it:
–DreamHost Tech Support