When I run a command program (rails 3/ruby 1.9.2) as this:
class MsdsAttr < ActiveRecord::Base include MsdsAttrModule belongs_to :attribute_record, :polymorphic => true has_many :attribute_values, :foreign_key => 'attribute_id' has_many :alt_values, :as => :alternative has_many :msds_ingredients end
ActiveRecord::Base.establish_connection( :adapter => "mysql", :host => "localhost", :database => "univ_parse_dev", :user => "PZZ", :password => "PZZ" )
attr = MsdsAttr.find(:first)
I get the error below even though I didn't try to connect using root. Running rails server/console etc doesn't have this problem ..
C:\inetpub\wwwroot\Larry\univ-parse>ruby db-test.rb C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/lib/ active_record/connect ion_adapters/mysql_adapter.rb:614:in `real_connect': Access denied for user 'roo t'@'localhost' (using password: YES) (Mysql::Error) from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/mysql_adapter.rb:614:in `connect' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/mysql_adapter.rb:164:in `initialize' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/mysql_adapter.rb:36:in `new' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/mysql_adapter.rb:36:in `mysql_connection' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:229:in `new_connection' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:237:in `checkout_new_conne ction' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:191:in `block (2 levels) i n checkout' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:187:in `loop' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:187:in `block in checkout'
from C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:186:in `checkout' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:94:in `connection' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_pool.rb:317:in `retrieve_connectio n' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_specification.rb:97:in `retrieve_c onnection' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/connection_adapters/abstract/connection_specification.rb:89:in `connection ' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation.rb:370:in `block in method_missing' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation.rb:125:in `scoping' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation.rb:370:in `method_missing' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation/query_methods.rb:182:in `build_arel' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation/query_methods.rb:149:in `arel' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation.rb:64:in `to_a' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation/finder_methods.rb:341:in `find_first' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation/finder_methods.rb:122:in `first' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.9/ lib/active_r ecord/relation/finder_methods.rb:105:in `find' from C:in `find' from db-test.rb:18:in `<main>'
C:\inetpub\wwwroot\Larry\univ-parse>