From: Jeremy Kemper <jeremy@...>
Date: 2005-12-10T07:48:52+09:00
Subject: Re: Rails & MySQL login problem (#42000Access denied for user)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Dec 9, 2005, at 2:32 PM, Lou Vanek wrote:
> It looks like ActiveRecord 1.13.1 for some reason is now trying to
> log on using the new authentication method that MySQL 4.1+ uses.
> A bug has been filed for this.

Because AR bundles the latest version of the pure-Ruby mysql driver
(0.2.6) along with a patch to support 4.1/5.0 servers.  The patch has
a bug which breaks compatibility with 3.23/4.0.


> In the mean time you may want to either revert your rails gems,
> update the database, or perform some fu on mysql.rb 'real_connect'.

Or install the mysql-ruby C bindings, which have always worked:
   gem install mysql

jeremy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (Darwin)

iD8DBQFDmgnMAQHALep9HFYRAo+uAJwP4MObhdmSPrjAozx3LQIDRVd0zQCeN/+t
5KlqkTyPd44okQLsRG8RPXI=
=QkrT
-----END PGP SIGNATURE-----