unable to create mysql db in rails

so when i used rake db:create

(<unknown>): could not find expected ':' while scanning a simple key at line 14 column 3

So, what is line 14 ?

... and should i keep test and production same in config/database.yml ??

The "same" as what?

The “same” as what? i mean to say test and production code same as in default

Uh, what? Even if you're using a code editor that doesn't show line numbers, I would hope you can count.

But please, start by installing a suitable editor.

thanks for reply…

i changed

socket:/tmp/mysql.sock to socket: /tmp/mysql.sock and thar error has gone but i face new error now…it says

rake aborted!

Please install the mysql2 adapter: gem install activerecord-mysql2-adapter (mysql2 is not part of the bundle. Add it to Gemfile.)

…learning rails in ubuntu has been lot harder than i thought :(…thx

And it will be hard forever, if you don't read and act on the messages you're presented with. The above gives you specific actions to take; have you done them? If not, why not?

thanks for reply... i changed socket:/tmp/mysql.sock to socket: /tmp/mysql.sock and thar error has gone but i face new error now..it says

rake aborted! Please install the mysql2 adapter: `gem install activerecord-mysql2-adapter` (mysql2 is not part of the bundle. Add it to Gemfile.) ...learning rails in ubuntu has been lot harder than i thought :(...thx

Try railstutorial.org, which is free to use online. You might find it an easier way to get started as it leads you through the basic principles one step at a time.

Colin