Development Environment Problem

Here's the message I get when I try to start a development

Loading development environment.
D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in 'load':ArgumentError:
syntax error on line 18, col 2: ' host: localhost'

Recently had some MySQL problems and now I get a 500 error on

No idea what blew up. Had been very stable until yesterday.

Any ideas would be appreciated.

What's on the line before it? If that doesn't help, post the whole
database.yml file (mask out any passwords of course).

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

Is the "password:" line really blank, or did you just remove the password?
It looks like that's actually the line that's giving it trouble.

Make sure there are no tabs where there should be spaces, and that there's
no whitespace at the end of the line; I don't know if either is *supposed*
to matter to YAML, but Ruby and tabs can do weird things on Windows.

Try switching the order of the password: and username: lines, and see if
the error now lists username instead of host. And (assuming the passwords
are the same or really blank) try swapping two of the password: lines, or
retyping the line from scratch. Look at the file in a hex editor and see
if there's anything weird with line endings (CRLF vs LF).

You solved it! Genius!

It was a missing white space.

Things seem fine again.