More information about the Underscore mailing list

[_] Accessing hosted MySQL databases

Tom Gidden tom at gidden.net
Thu Jun 5 10:38:22 BST 2008

On 5 Jun 2008, at 10:30, Rick Hurst wrote:

> On Thu, Jun 5, 2008 at 10:12 AM, Jason Nevin  
> <jason_nevin at yahoo.co.uk> wrote:
>> I've passed this to our network guys and the head scratching has  
>> begun.  Do I need any software on my PC to facilate this or does  
>> magic take place in the router?
>
> are you using windows? if so you can install a free program called
> putty on your machine,
> ...
> Then with your gui mysql app you connect to e.g. localhost:33060 which
> will connect you to your remote database.


Alternatively, a good MySQL GUI app will support SSH tunnelling  
itself.  On the Mac, Navicat Lite (free) does.  I assume the Windows  
version of Navicat does too.

Then it's just a case of following the instructions... no other setup  
is necessary, assuming your hosting provider allows SSH port  
forwarding.  If not, then it's a wash anyway.

Tom

-- 
Tom Gidden
http://gidden.net/tom