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
--
Regards,
Zaky Katalan-Ezra
QA Administrator
www.IGeneriX.com
Sites.IGeneriX.com
054-7762312
-- 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 <jeremyburns@classoutfit.com> wrote:
Thanks - I was hoping that someone could suggest a database.php setting that would make the connection.
--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
>> cake-php+unsubscribe@googlegroups.com 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
> cake-php+unsubscribe@googlegroups.com 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
cake-php+unsubscribe@googlegroups.com 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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
No comments:
Post a Comment