Cannot connect to MySql

rubyonrails-talk
1

HI Everyone,

me new to Ruby on Rails, For me its getting difficult to connect To Database . Previously i followed some tutorial and installed sqlite , Now when i change the configuration file (database.yml)configurations from sqlite to mysql im getting problems.

when me trying to hit the following command. C:\rails\connect>ruby script/generate controller list me getting the following error.

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_a dapters/abstract/connection_specification.rb:218:in `establish_connection': deve lopment database is not configured (ActiveRecord::AdapterNotSpecified)         from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record /connection_adapters/abstract/connection_specification.rb:209:in `establish_conn ection'         from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:332:i n `initialize_database'         from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:120:i n `process'         from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:93:in `send'         from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initializer.rb:93:in `run'         from C:/rails/connect/config/environment.rb:13         from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `ge m_original_require'         from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `re quire'         from c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/generate.rb :1         from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `ge m_original_require'         from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `re quire'         from script/generate:3

                     Thanks for help in advance.

2

Hi

I guess each beginner on rails would face this problem I faced it too when i started working on rails :slight_smile:

the solution is to create a new project using this command

rails project -d mysql

-d mysql will generate the database.yml for mysql in accordance to your platform

so copy this file and paste it in your original project, restart the server, and enjoy

if anyone has a better way, please do tell us

thanks