Need a guru: phpmyadmin / nginx / proxy / ssh
New to Linode, and new to nginx, which I'm playing with because I hear Wordpress absolutely screams on nginx. So I'm in the process of setting stuff up and migrating an existing WP site, when I get to the phpmyadmin issue.
I set up my Linode with the "better Wordpress" nginx StackScript on Ubuntu 12.04. And I've spent a full day Googling around looking for the best tutorials and walk-throughs about getting phpMyAdmin running on the box. Best I could do was getting running at domainname/phpMyAdmin, and obviously that just won't do.
I contacted Support, and when I asked if they could point me toward a decent resource, they said the following:
> The best way to secure it is to find a way to run PHPmyAdmin on local host and then proxy into your Linode to use it. This will keep it from being exposed to the outside world and still allow you access if you ssh tunnel.
Then another techie weighed in and said the best place to go for advice on how to do THAT was to come here to the Community, where y'all would be ridiculously happy to help me figure this thing out. The "run on local host" is easy. It's the rest that makes my brain hurt.
Thanks. And hi, by the way. Nice place you have here.
