SSH Tunnel Manager & CocoaMysql

July 30, 2007 @ 11:22 PM | posted by carmelyne

(last updated: 07.31.07)

Port Forwarding & connecting remotely to MySQL on your Slice

First, lets set up the forwarding ports using the SSH Tunnel Manager. I usually start with the 29000 ports so there's no conflicts with registered ports. Go to the preferences on SSHTM and add a new connection. Pictures are better than words so here's how the SSHTM set up looks like:

Lastly, setting up CocoaMySQL to connect remotely to the MySQL on your slice using the forwarded ports under preferences:

It's easy and you can easily put two and two together with the screenshots. That's it!

Note:
The SSHTM user/login is generally your server/slice login and the MySQL login is usually different than the sever login so just take note. This set up is for SliceHost but should be general enough to use on other VPS set ups.

[ Last updated: July 31, 2007 @ 09:32 AM ]

Filed in Dev Tools, Playground, Thoughts


2 Responses to...
“SSH Tunnel Manager & CocoaMysql”

  1. Colin:

    Cool tip. SSH Tunnels are a pain to get set up. This makes it easier than having multiple iTerm tabs open for each connection. Thanks!



    Posted: August 7th, 2007 at 11:06 AM
  2. carmelyne:

    Thank you as well. ;p



    Posted: August 7th, 2007 at 05:02 PM

Sorry, comments are closed for this article.

Snippets of 06/24/07

Rails 'A'..'Z' Paginate

1
2
3
4
5
6
7
8
9
10
11

# Starts with 'A'..'Z' Paginate / model
def self.sort(sort)
  if sort
    find(:all, :conditions => ['name LIKE ?', "#{sort}%"])
  else
    find(:all, :order => 'name')
  end  
end

# index action / controller
@models = Model.sort(params[:sort])
RailsConf 2006
I heart devChix