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.