MySQL access from within Ruby

[peterv6]

I'm a Ruby Newbie, and I haven't been able to find any information on accessing a MySQL database using Ruby. Can anyone post some code that does that, or point me to some documentation that will show me what I need and how to connect to and use a MySQL database? All help will be greatly appreciated!

PETERV
Syracuse, NY &
Boston, MA

 

[grande]

All you should have to do is tell it to use a MySQL database in the file config/database.yml

development:
  adapter: mysql
  database: My_development_Database
  username: UserName
  password: 
  host: localhost

-------------------------
Call me barely Impressive Captain.

 

[peterv6]

Unfortunately, this solution isn't what I'm really looking for. What I need is a way to use the Ruby DBI from within a Ruby script to connect to the MySQL database.

PETERV
Syracuse, NY &
Boston, MA