# mySQL + ROR connection - please help

**URL:** <https://www.ruby-forum.com/t/mysql-ror-connection-please-help/125462>\
**Category:** Rails\
**Created:** [January 9, 2008, 9:47am UTC](https://www.ruby-forum.com/t/mysql-ror-connection-please-help/125462 "2008-01-09T09:47:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sameera](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/b487fb/32.png) [@sameera](https://www.ruby-forum.com/u/sameera)\
**Post date:** [January 9, 2008, 9:47am UTC](https://www.ruby-forum.com/t/mysql-ror-connection-please-help/125462/1 "2008-01-09T09:47:57Z")

</div>

Hi guys,

I have created a ROR web application and i want to it connect to a  
remote mySql database (in another machine).

I was able to connect to the mySQL database through mySqlCilent GUI. But  
i couldnt connect through my ruby app.

following are the details.

my database.yaml

# MySQL (default setup). Versions 4.1 and 5.0 are recommended.

# 

# Install the MySQL driver:

# gem install mysql

# On MacOS X:

# gem install mysql – --include=/usr/local/lib

# On Windows:

# There is no gem for Windows. Install mysql.so from RubyForApache.

# [http://rubyforge.org/projects/rubyforapache](http://rubyforge.org/projects/rubyforapache)

# 

# And be sure to use new-style password hashing:

# [http://dev.mysql.com/doc/refman/5.0/en/old-client.html](http://dev.mysql.com/doc/refman/5.0/en/old-client.html)

production:  
adapter: mysql  
database:   
username:   
password:   
host: Ex : 192.168.0.445

development:  
production

* * *

and the error says,

wrong number of arguments (1 for 0)

RAILS\_ROOT: ./script/…/config/…

Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/vendor/mysql.rb:551:in  
`initialize' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/vendor/mysql.rb:551:in `new’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/vendor/mysql.rb:551:in  
`scramble41' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/vendor/mysql.rb:141:in `real\_connect’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:330:in  
`connect' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:87:in `initialize’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:36:in  
`new' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:36:in `mysql\_connection’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:251:in  
`send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in `connection\_without\_query\_cache=’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/query\_cache.rb:54:in  
`connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in `retrieve\_connection’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:696:in `columns’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/base.rb:1969:in  
`attributes_from_column_definition' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1351:in `initialize\_without\_callbacks’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/callbacks.rb:236:in  
`initialize' #{RAILS_ROOT}/app/controllers/test_controller.rb:4:in `new’  
#{RAILS\_ROOT}/app/controllers/test\_controller.rb:4:in `index’

* * *

please help

thank you in advance

cheers

sameera