Password in development environnement

Hi Everyone,

I noticed a strange behavior from Rails, When there's password in the
development environnement Rails give me this error

<<Mysql::Error: Lost connection to MySQL server during query: SHOW
FIELDS FROM comics>>

When I removed the password everything works.

Here's my database.yml

development:
  adapter: mysql
  database: comics_catalog_dev
  username: admin_comic
  password: comic
  host: localhost

So when I have the configuration shown below, It is working.

development:
  adapter: mysql
  database: comics_catalog_dev
  username: admin_comic
  password:
  host: localhost

Have someone ever experience this kinda problem?

You're maybe using MySQL 4.1 and there's problem with the password hashing.

Take a look at http://www.mikekrisher.com/?p=386

Yes I'm using MySql 4.1

So I just need to upgrade to a newer version.

Thank you.