From: Stephan <nospam@...>
Date: 2005-12-10T17:52:38+09:00
Subject: Re: Rails & MySQL login problem (#42000Access denied for user)

Yan-Fa Li wrote:
> 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
> 
> 

Thanks for your help, but I still didn't get it working.

I have MySQL version 4.1.15 and I have set old_passwords=0 in the MySQL 
config file. So the MySQL version should not be a problem here, right?

I installed the gem with the command given above, with the following result:
gem install mysql -- --with-mysql-lib=/usr/lib/mysql
<...cut...>
Successfully installed mysql-2.7

After this the problem remains. There is a slight difference in the 
error message, it is now: "Access denied for user 'members'@'localhost' 
to database 'dev_members'", so the error number is missing now.

Any more ideas?


Stephan