Dave - I got a perfect solution to this a few days ago from Zaky Katalan-Ezra.
My challenge wasn't connecting to a remote db via SSH using a client (I use
Sequel Pro) as that works great. What I wanted to do was to create a
database.php configuration that would allow a local Cake app to connect to the
remote db, which means that all (distributed) developers can develop and test
against a single database.
For good measure, here is Zaky's response:
edit /etc/ssh/sshd_config on your local machine
Add:
AllowTcpForwarding yes
GatewayPorts yes
restart sshd
Edit my.cnf on remote machine.
Uncomment the following line.
bind-address = 127.0.0.1
restart mysql
On you local machine run the following command
ssh -i e-keypair -f remoteu...@remote.com -N -L 4444:localhost:3306
If you are not using ssh key you will be prompt for remote user assword
Edit database.php
var $default = array(
'driver' => 'mysqli',
'persistent' => false,
'host' => '127.0.0.1',
'port'=>4444,
'login' => 'user',
'password' => 'pass',
'database' => 'schema',
'prefix' => ''
);
Jeremy Burns
Class Outfit
jeremybu...@classoutfit.com
http://www.classoutfit.com
On 27 Jan 2011, at 22:13, Dave Maharaj wrote:
> I just setup mySQL workbench on my local machine to connect to my server /
> sql database.
> I do not want phpmyAdmin so I use this to administer my db’s.
> It connects thru the ssh tunnel. Is that what your looking for? I did not
> connect it to my localhost (my home machine) though so if that’s what you are
> in need of I am unsure of that aspect but will follow this post to see if
> anyone else does.
>
> Dave
>
> From: Jeremy Burns [mailto:jeremybu...@classoutfit.com]
> Sent: Tuesday, January 25, 2011 4:02 PM
> To: cake-php@googlegroups.com
> Subject: Connecting to a remote database via SSH
>
> 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+unsubscr...@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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
