Manual active record db connection in ruby using mysql adapter

November 12, 2009April 16, 2010 by sandipransing, posted in Ruby on Rails

Here is the code to make manual connection with database

 
require 'active_record'
ActiveRecord::Base.establish_connection(
    :adapter  => "mysql",
    :host     => "localhost",
    :username => "root",
    :password => "abcd",
    :database => "funonrails"
  )

Load database configurations from yml file

 
dbconfig = YAML::load(File.open('database.yml'))
ActiveRecord::Base.establish_connection( dbconfig )

2 thoughts on “Manual active record db connection in ruby using mysql adapter”

Anonymous says:

January 6, 2010 at 15:53

getting for the code above uninitialized constant YAML (NameError)what should i do?help me out

Reply
Sandip Ransing says:

January 6, 2010 at 16:27

This is because YAML libray is not installed or not in path.Add library to your code before that ensure it exists.require "yaml"dbconfig = YAML::load(File.open('database.yml'))ActiveRecord::Base.establish_connection( dbconfig )

Reply