鈴木です。

望月さん、問題は解決してるでしょうか？
まだのようでしたら、rails list の方で同じような問題への対処の仕方が
流れてましたので以下に引用してみます。参考になれば


From:  Duzenbury, Rich <rduzenbury@b...>
Date: 2006/07/28 0:43
Subject: RE: [Rails] Connecting to mysql 4.1.12 server SOLVED
To: rails@l...

> -----Original Message-----
> From: rails-bounces@l... [mailto:rails-
> bounces@l...] On Behalf Of Duzenbury, Rich
> Sent: Wednesday, July 26, 2006 5:02 PM
> To: rails@l...
> Subject: [Rails] Connecting to mysql 4.1.12 server
>
> Hi,
>
> I'm building a rails app on win32, and need to develop, test, and
deploy
> to a mysql 4.1.12 server running on a Linux server.
>
> Whenever I attempt to connect to the database_development or
> database_test directly from my workstation, I get the 'Lost connection
> to MySQL server during query', however, I can connect directly from my
> local mysql client on my workstation with no difficulty:
>

The problem is that the 4.1.12 database had old privilege tables from a
previous release.  I fixed the privilege tables via these instructions:

http://dev.mysql.com/doc/refman/4.1/en/mysql-fix-privilege-tables.html

Then, I had to restart the mysql server 'select password('foo')' still
returned a short password.

Then, I changed the password used by the rails userid so it would
generate a long password in the mysql.user table.

Restarted WebBrick and everything works fine now.

-- 
M.Suzuki

--
ML: rails@r...
使い方: http://QuickML.com/