Jeremy Kemper wrote:
> 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

On FC4 you may need to type:

sudo gem install mysql -- --with-mysql-lib=/location/of/your/mysqllibs

e.g. sudo gem install mysql -- --with-mysql-lib=/usr/lib64/mysql

on an AMD64 system


Yan