mysql2-example.rb

#!/usr/bin/env ruby
require 'mysql2'

mysql = Mysql2::Client.new(:default_file => '/root/.my.cnf', :default_group => 'client')
mysql.query_options.merge!(:symbolize_keys => true)
result = mysql.query("SELECT siteid,servername,port FROM qa34ga.SiteUrls;")
result.each { |x| p x }

#  {:siteid=>1,    :servername=>"www.qa34ga.mydomain.com",                                      :port=>80}
#  {:siteid=>502,  :servername=>"graduationtest.qa34ga.mydomain.com",                           :port=>80}
#  {:siteid=>503,  :servername=>"delete.qa34ga.mydomain.com",                                   :port=>80}
#  {:siteid=>504,  :servername=>"fifty.qa34ga.mydomain.com",                                    :port=>80}
#  {:siteid=>505,  :servername=>"test.qa34ga.mydomain.com",                                     :port=>80}
#  {:siteid=>507,  :servername=>"testideaagarwal1.qa34ga.mydomain.com",                         :port=>80}
#  {:siteid=>509,  :servername=>"howcanwebringaboutachangeinourdemocracy.qa34ga.mydomain.com",  :port=>80}
#  {:siteid=>510,  :servername=>"bug34044.qa34ga.mydomain.com",                                 :port=>80}
#  {:siteid=>511,  :servername=>"jimenachallengedraft.qa34ga.mydomain.com",                     :port=>80}