Re: MySQL with windows

Jon Dean wrote:
> I am new to both ruby and am trying to install the API for mysql using 
> the link http://raa.ruby-lang.org/project/mysql-ruby/. I am using 
> version 1.8.4 for ruby and 5.0.19-nt for mysql. Following the 
> readme-winpkg I entered ruby install.rb -n and got
> install
> mingw32/mysql.so => c:/ruby/lib/ruby/site_ruby/1.8/i386-msvcrt
> I then ran the simple.rb
> # simple.rb - simple MySQL script using Ruby MySQL module
> 
> require "mysql"
> 
> begin
> # connect to the MySQL server
> dbh = Mysql.real_connect("localhost", "testuser", "testpass", "test")
> # get server version string and display it
> puts "Server version: " + dbh.get_server_info
> rescue MysqlError => e
> print "Error code: ", e.errno, "\n"
> print "Error message: ", e.error, "\n"
> ensure
> # disconnect from server
> dbh.close
> end
> from http://www.kitebird.com/articles/ruby-mysql.html and got:
> Error code:1251
> Error message: Client does not support authentication protocol requested 
> by server; consider upgrading mysql client
> simple.rb:13: undefined method 'close' for nil:NilClass <NoMethodError>
> 
> Are there any suggestion on how I can get the ruby API for mysql 
> installed and running?
> 

Run irb, and see what version your client is..

   require 'mysql'
   Mysql.client_info

Chances are it's a 4.0.x client and it doesn't support normal password hash mechanism used by mysql 4.1.x
and 5.0.x. You can
google around and look for a windows mysql.so binary for mysql 5

Zach