Ruby で MySQL に接続できるようにする

いつになったら、Ruby 1.9 系で安定して MySQL に接続できるようになるのだろうか。
MySQL は XAMMP でインストールされるものを利用。

C:\>ruby -v
ruby 1.8.7 (2009-12-24 patchlevel 248) [i386-mswin32]

C:\>gem install dbi
Successfully installed deprecated-2.0.1
Successfully installed dbi-0.4.3
2 gems installed
Installing ri documentation for deprecated-2.0.1...
Installing ri documentation for dbi-0.4.3...
Installing RDoc documentation for deprecated-2.0.1...
Installing RDoc documentation for dbi-0.4.3...

C:\>gem install dbd-mysql
Successfully installed dbd-mysql-0.4.3
1 gem installed
Installing ri documentation for dbd-mysql-0.4.3...
Installing RDoc documentation for dbd-mysql-0.4.3...

C:\>irb
irb(main):001:0> require 'rubygems'
=> true
irb(main):002:0> require 'dbi'
=> true
irb(main):003:0> dbh = DBI.connect('DBI:mysql:database:localhost', 'user', 'password')
=> #<DBI::DatabaseHandle:0x2d72984 @driver_name="Mysql", @trace_mode=nil, @handle=#<DBI::DBD::Mysql::Database:0x2d72678 @have_transactions=true, @handle=#<Mysql:0x2d72754>, @attr={"AutoCommit"=>true}, @mutex=#<Mutex:0x2d72524>>, @trace_output=nil, @convert_types=true>
irb(main):004:0> dbh.select_one('SELECT VERSION()')
=> ["5.1.33-community"]
irb(main):005:0>