Ruby on rails $ mysql configuration

Question

I want to configure mysql instead of Sqlite3. I had already configured the database.yml file:

development:
  adapter: mysql
  database: test
 username:false
 password:neha
 host :localhost
 port:3306

and also installed the mysql gem using gem install mysql

still i stuck out in error...please help me out :\rails\TestApp1>ruby script/server

Booting WEBrick Rails 2.3.11 application starting on http://0.0.0.0:3000 :/Ruby192/lib/ruby/1.9.1/syck.rb:135:in load': syntax error on line 13, col 0:test:' (ArgumentError) from C:/Ruby192/lib/ruby/1.9.1/syck.rb:135:in load' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/rails-2.3.11/lib/initializer.rb:926:indatabase_configuration' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/rails-2.3.11/lib/initializer.rb:437:in initialize_database' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/rails-2.3.11/lib/initializer.rb:141:inprocess' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/rails-2.3.11/lib/initializer.rb:113:in run' from C:/rails/TestApp1/config/environment.rb:9:in' from :29:in require' from <internal:lib/rubygems/custom_require>:29:inrequire' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:182:in block in require' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:547:innew_constants_in' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:182:in require' from C:/Ruby192/lib/ruby/gems/1.9.1/gems/rails-2.3.11/lib/commands/server.rb:84:in' from :29:in require' from <internal:lib/rubygems/custom_require>:29:inrequire' from script/server:3:in `' i got this error

@d11wtq:
here is my yml file for mysql configuration:

ActiveRecord::Base.establish_connection(
:adapter => "mysql",
:host => "localhost",
:username => "root",
:password => "neha",
:database => "ruby"
)
& where i have to put
require 'mysql'

d11wtq · Accepted Answer · 2011-05-07 12:32:35Z

1

Looking at that log output you've now posted, it looks like you have haven't formatted that .yml file correctly. The use of whitespace in YAML is absolutely critical. Indent with spaces, not tabs, and make sure your indentation is consistent within each level. It appears that the lines are all aligned differently in your file, which is causing syck (the YAML parser) to throw an Exception.

EDIT | You also want to make the spacing between the key, the semi-colon and the value consistent too. Take pride in the layout of your code and you'll enjoy coding more ;) But pride or not... YAML is (intentionally) picky about whitespace.

answered May 7, 2011 at 12:32

d11wtq

35.3k20 gold badges127 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikash Agarwal · Accepted Answer · 2020-09-17 06:15:36Z

1

Have your yml files properly indented and you will not be getting syntax error anymore. Also add mysql2 compatible version in your Gemfile, so that while you will be deploying it to any server it will take from Gemfile automatically.

answered Sep 17, 2020 at 6:15

Vikash Agarwal

417 bronze badges

Comments

d11wtq · Accepted Answer · 2011-05-07 07:43:14Z

0

Did you add "mysql" to your Gemfile and run "bundle install"?

answered May 7, 2011 at 7:43

d11wtq

35.3k20 gold badges127 silver badges200 bronze badges

1 Comment

nehit Over a year ago

hey can anyone send me the any article reagarding the configuration of mysql in ruby on rails.

Kyle Sletten · Accepted Answer · 2011-05-07 07:48:38Z

0

If you're working on Windows, I know that I didn't have the MySQL C Driver installed on my machine. It's a different download than the MySQL Community Server. You also have to make sure that your PATH has the route to the C driver. Download the driver here.

answered May 7, 2011 at 7:48

Kyle Sletten

5,4333 gold badges28 silver badges39 bronze badges

Collectives™ on Stack Overflow

Ruby on rails $ mysql configuration

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related