Hacker News Reader

Sequel Pro's built-in SSH tunnel has worked for me in every remote development situation I've encountered.

It seems like a really bad idea to place a web-based database tool on a public-facing host when technology exists to route MySQL through SSH.

Even shared hosts support SSH these days. If yours doesn't, maybe it's time to find another shared host!

View on HN

It's been a while but I'm pretty sure you can do so with PHPMyAdmin.

I seem to remember installing it on my own workstation, setting up the ssh tunnel and then pointing PHPMA to localhost.

It's not my favorite tool and I've avoided it due to security concerns but I've set it up for others as described and I recall it worked fine. Like I said though it's been a while and I'm fuzzy on the details.

Reply on news.ycombinator.com