ruby mysql error


I am getting a mysql error while running a ruby file on my system (Windows):

D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read': Client does not support authentication protocol requested by server; consider upgrading MySQL c lient (Mysql::Error)         from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real_connect'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:576:in `connect'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:204:in `initialize'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:76:in `new'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:76:in `mysql_connectio n'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:223:in `sen d'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:223:in `new _connection'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:245:in `che ckout_new_connection'          ... 16 levels...         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/base.rb:1991:in `all_attributes_exists?'         from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/base.rb:1847:in `method_missing'         from test1.rb:28:in `select_type'         from test1.rb:39

I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone through google:

but it did not help. Do I need to make any configuration for this?

Thanks in advance -gourav

Can you verify if following things are in proper place.

1. Are you able to connect to mysql otherwise on your system. 2. Have you done $gem install mysql 3. Copy libmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/ bin folder 3. Verify database.yml has your password


Thanks for your reply Vipin,

I am able to connect to Mysql through command prompt and mysql query browser.

Also, I am able to connect to a remote system by mysql query browser tool. I have copied ibmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/bin folder

I have mysql gem installed 2.7.1

but it still doesn't work.


The message said, update your MySQL client, reverify your conf file, and try again. What MySQL version have you?

Hi Gerardo, I am using "MYSQL Ver 14.12 Distrib 5.0.77, for Win32 (ia32)"

Another strange thing I noticed is I am able to run a rails(2.2.2) application here, without any issue.