More information about the Underscore mailing list

[_] Accessing hosted MySQL databases

Rick Hurst rick.hurst at gmail.com
Thu Jun 5 10:30:16 BST 2008

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?

Here's roughly how you do it:-

are you using windows? if so you can install a free program called
putty on your machine, you then configure a tunnel to your server
using that (you'll have to google for instructions on that bit) which
means that you set up a tunnel that forwards all local requests for
e.g. port  33060 on your local machine to port 3306 on the remote
machine. (I specified 33060 in case you have mysql running on 3306 on
your machine, to avoid a clash)

Then with your gui mysql app you connect to e.g. localhost:33060 which
will connect you to your remote database.




-- 
Rick Hurst, Web developer, Bristol, England
http://www.rickhurst.co.uk