[_] 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