setting-up-a-remote-environment

gist-1.sh

$ vi ~/.ssh/config

# Add the following information

Host rails_blog_db
HostName 0.0.0.0 # your remote's public facing IP
Port 3122
User jjackson # your username
LocalForward 3307 192.168.100.1:3306

gist-2.rb

# ~$ touch rails_blog/config/environments/development_remote.rb
# ~$ vi config/environments/development_remote.rb

# Add this and save!
require File.join(File.expand_path(File.dirname(__FILE__)),'development')

gist-3.yml

# rails_blog/config/database.yml

default: &default
  adapter: mysql
  username: rails_blog_user
  password: ENV['your_super_secret_password']
  host: 192.168.100.1

development:
  database: rails_blog_development
  <<: *default

production:
  database: rails_blog
  <<: *default

# set the database option to your development db and the host to your
# ssh forward

development_remote:
  database: rails_blog_development
  host: 127.0.0.1
  port: 3307  # This is where the ssh is forwarding your DB traffic
  <<: *default

gist-4.rb

# rails_blog/config/application.rb

require File.expand_path('../boot', __FILE__)

require 'rails/all'

if defined?(Bundler)
  # Add your new development_remote environment to the assets hash below
  Bundler.require(*Rails.groups(:assets => %w(development development_remote test)))
end

# Rest of file...