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. -gourav On Jun 1, 5:28 pm, Vipin <[email protected]> wrote: > On Jun 1, 4:44 pm, Gourav Tiwari <[email protected]> wrote: > > > > > Hi, > > > 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:http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795htt...... > > > 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 > > vipin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
