1. You need port 22 and 3306 to be open on the remote server 2. Install mysql workbench 3. In the new connection form set the connection method to tcp over ssh. 4. If you are using terminal and not GUI use ssh tunnel.
And you may find more info here: http://forums.mysql.com/read.php?30,249779,249779 On Wed, Jan 26, 2011 at 7:21 AM, Jeremy Burns | Class Outfit < [email protected]> wrote: > Thanks - I was hoping that someone could suggest a database.php setting > that would make the connection. > > Jeremy Burns > Class Outfit > > [email protected] > http://www.classoutfit.com > > On 26 Jan 2011, at 05:01, bdwilton wrote: > > > Not sure if this is exactly what you had in mind, but... > > > > If you have a local work server with a local router which you can open up > a port on you can use a SSH tunnel on your local work server to forward that > port to a remote VPN or remote server which has its ports locked down but > accessible to your IP. This opens up the port through your router to be > accessed externally but through SSH to the remote server. > > > > Just look up SSH Tunnel. > > > > Brett Wilton > > http://wiltonsoftware.com > > > > On 26/01/2011 8:32 a.m., Jeremy Burns wrote: > >> Does anyone have any ideas for how to connect to a remote database via > SSH? It's a development thing so that people working remotely can develop > against the same database hosted on our virtual server. -- > >> Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > >> Check out the new CakePHP Questions site http://ask.cakephp.org and > help others with their CakePHP related questions. > >> > >> > >> To unsubscribe from this group, send email to > >> [email protected]<cake-php%[email protected]>For > >> more options, visit this group at > http://groups.google.com/group/cake-php > > > > -- > > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org Check out the new CakePHP Questions site > http://ask.cakephp.org and help others with their CakePHP related > questions. > > > > > > To unsubscribe from this group, send email to > > [email protected]<cake-php%[email protected]>For > > more options, visit this group at > http://groups.google.com/group/cake-php > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php > -- Regards, Zaky Katalan-Ezra QA Administrator www.IGeneriX.com Sites.IGeneriX.com 054-7762312 -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
