How do I use Ruby to connect to a MySql database outside of Rails as a scripting language

Question

Hi Im using Ruby as a scripting language. Not for web development, but to connect to a local database on my computer and manipulate it.

Id like to know how I can connect. Do I need to download/import tools? What do I need to get started?

Thanks,

Update

I did gem install mysql2 and ran the following ruby file

require 'mysql2'  

#my = Mysql.new(hostname, username, password, databasename)  
con = Mysql.new('localhost', 'nverma', 'something', 'ruby')  
rs = con.query('select * from contacts')  
rs.each_hash { |h| puts h['name']}  
con.close

and got the following error:-

/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext
 /kernel_require.rb:55:in `require': dlopen(/Library/Ruby/Gems/2.0.0/gems/mysql2-0.3.16/lib/mysql2 
 /mysql2.bundle, 9): Library not loaded: libmysqlclient.18.dylib (LoadError)
 Referenced from: /Library/Ruby/Gems/2.0.0/gems/mysql2-0.3.16/lib/mysql2/mysql2.bundle
 Reason: image not found - /Library/Ruby/Gems/2.0.0/gems/mysql2-0.3.16/lib/mysql2/mysql2.bundle
 from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext 
 /kernel_require.rb:55:in `require'
 from /Library/Ruby/Gems/2.0.0/gems/mysql2-0.3.16/lib/mysql2.rb:8:in `<top (required)>'
 from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext
 /kernel_require.rb:135:in `require'
 from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext
 /kernel_require.rb:135:in `rescue in require'
 from /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/rubygems/core_ext
 /kernel_require.rb:144:in `require'
 from sol5.rb:1:in `<main>'

Please help!

Look at the mysql2 gem.

August
– August

2014-07-31 05:08:06 +00:00
Commented Jul 31, 2014 at 5:08 — August
– August, Commented Jul 31, 2014 at 5:08
Please have a look on the updated question!

nimeshkiranverma
– nimeshkiranverma

2014-07-31 05:42:35 +00:00
Commented Jul 31, 2014 at 5:42 — nimeshkiranverma
– nimeshkiranverma, Commented Jul 31, 2014 at 5:42

infused · Accepted Answer · 2014-07-31 05:18:47Z

3

One option is to use the mysql2 gem:

gem install mysql2

Connect to your database:

client = Mysql2::Client.new(:host => "localhost", :username => "root")

Query the database:

results = client.query("SELECT * FROM users")

answered Jul 31, 2014 at 5:18

infused

24.5k13 gold badges71 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davetakahashi · Accepted Answer · 2014-07-31 06:12:04Z

0

Looking at your update, is the Mysql class your own class? If so can you post that code also?

If not and you are trying to use mysql2 directly here, then you need instantiate the db connection the way @infused said in the other answer:

con = Mysql2::Client.new(host: "localhost", username: "root")

answered Jul 31, 2014 at 6:12

davetakahashi

4941 gold badge4 silver badges12 bronze badges

Collectives™ on Stack Overflow

How do I use Ruby to connect to a MySql database outside of Rails as a scripting language

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related