connecting Ruby to Mysql without rails

Question

How can i connect Ruby to Mysql without rails? I want to use Ruby standalone to write pure ruby code to make web application. with no abstraction

Answer 1

Look here

require "mysql"    # if needed

@db_host  = "localhost"
@db_user  = "root"
@db_pass  = "root"
@db_name = "your_db_name"

client = Mysql::Client.new(:host => @db_host, :username => @db_user, :password => @db_pass, :database => @db_name)
@cdr_result = client.query("SELECT * from your_db_table_name')

Answer 2

install gem mysql (check that you have libmysqlclient-dev installed).

mysql = Mysql.new(host, user, password, database)
mysql.query("SELECT ...")
mysql.close

See the documentation for more information