# Working with mysql in ruby **URL:** \ **Category:** ruby-talk\ **Created:** [22 November 2012 14:33 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739 "2012-11-22T14:33:20Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [22 November 2012 14:33 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/1 "2012-11-22T14:33:20Z")
i have been trying to successfully connect ruby with mysql. there are a hundred examples with code and some using different gems. gems i have tried: mysql mysql2 dbi ruby-mysql the code examples i have found have been pretty much the same so im guessing its something with the gems, maybe they are not installing right, i tried moving them around to different files but it didnt make a difference. i have also read that mysql gem is not supported....so i want to start with a question before i post any code or ask for any code, does anyone know of a ruby-mysql gem that they have gotten to work, (by work i mean connect to mysql database, and interact with mysql through ruby) > **···** > > -- > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). ---
**Author:** ![Hassan\_Schroeder](https://yyz1.discourse-cdn.com/flex029/user_avatar/rubytalk.org/hassan_schroeder/32/1838_2.png) [@Hassan\_Schroeder](https://rubytalk.org/u/Hassan_Schroeder)\ **Post date:** [22 November 2012 14:58 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/2 "2012-11-22T14:58:52Z")
Absolutely; the mysql2 gem works fine standalone, or as part of a high percentage of current Rails apps. If you're having problems, post your code and the error message(s). > **···** > > On Thu, Nov 22, 2012 at 6:33 AM, john smith \ wrote: > > > does anyone know of a ruby-mysql gem that they have gotten to work, (by > > work i mean connect to mysql database, and interact with mysql through > > ruby) > > -- > Hassan Schroeder ------------------------ hassan.schroeder@gmail.com > > > **[Hassan Schroeder on about.me](https://about.me/hassanschroeder)** > > > > I use about.me to show people what matters most to me. > > twitter: @hassan ---
**Author:** ![GD1](https://avatars.discourse-cdn.com/v4/letter/g/6f9a4e/32.png) [@GD1](https://rubytalk.org/u/GD1)\ **Post date:** [23 November 2012 00:26 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/3 "2012-11-23T00:26:19Z")
Hi John, > does anyone know of a ruby-mysql gem that they have gotten to work, (by > work i mean connect to mysql database, and interact with mysql through > ruby) I can't speak for MySQL, but I've been using DBI with a PostgreSQL database for a project with simple database needs, and after the initial setup it has been fairly low-hassle to use. If I had to talk to a MySQL database at this point I'd try DBI first, but that's just me, and it could be bad advice. As a point of reference, I'm using DBI 0.4.5 with Ruby 1.9.2 p136 at present on this project. I hope this is of some use. Cheers, Garth > **···** > > On 23/11/12 01:03, john smith wrote: ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [23 November 2012 18:53 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/4 "2012-11-23T18:53:03Z")
Here is the error i get: C:/Ruby193/lib/ruby/site\_ruby/1.9.1/rubygems/custom\_require.rb:36:in `require': cannot load such fil e -- mysql (LoadError)         from C:/Ruby193/lib/ruby/site\_ruby/1.9.1/rubygems/custom\_require.rb:36:in `require'         from C:/Users/will/Notepad++/Databases/ruby\_DBI.rb:11:in `\' Here is my code: require 'rubygems' require 'mysql' begin   connect = Mysql.new 'root', 'user12', '34klq\*'   puts connect.get\_server\_info   rs = connect.query 'SELECT VERSION()'   puts rs.fetch\_row   rescue Mysql::Error =\> e     puts e.errno     puts e.error   ensure     connect.close if connect end This is the same type of problem i get no matter what gem i use or tutorial i follow. any help please. > **···** > > -- > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [25 November 2012 17:34 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/5 "2012-11-25T17:34:43Z")
here is another attempt.... code: require 'mysql' begin dbh = Mysql.new('root', 'user12', '34klq\*', 'mydb') puts dbh.get\_server\_info rs = dbh.query'SELECT VERSION()' puts rs.fetch\_row ensure   dbh.close if dbh end Result: C:/Ruby193/lib/ruby/site\_ruby/1.9.1/rubygems/custom\_require.rb:36:in `require': cannot load such fil e -- mysql (LoadError)         from C:/Ruby193/lib/ruby/site\_ruby/1.9.1/rubygems/custom\_require.rb:36:in `require'         from C:/Users/will/Notepad++/Databases/ruby\_DBI.rb:1:in `\' Any help would be appreciated thank you > **···** > > -- > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [25 November 2012 18:39 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/6 "2012-11-25T18:39:21Z")
I just tried reinstalling ruby, i installed the devkit. i do have vmware with ubuntu and bt5 that i could use, but im more comfortable with windows. do you know of any other database that works well with ruby that i could try? > **···** > > -- > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [25 November 2012 19:38 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/7 "2012-11-25T19:38:29Z")
I will try to figure out the issue with the gem not being found, i read a page a while ago about different ways to install the gem....i think with a -r switch or something ill see if i can find that again and reinstall and see if that does anything. Do you see anything wrong with the code its self? > **···** > > -- > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). ---
**Author:** ![Hassan\_Schroeder](https://yyz1.discourse-cdn.com/flex029/user_avatar/rubytalk.org/hassan_schroeder/32/1838_2.png) [@Hassan\_Schroeder](https://rubytalk.org/u/Hassan_Schroeder)\ **Post date:** [25 November 2012 18:23 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/8 "2012-11-25T18:23:47Z")
> here is another attempt.... OK, stop right there -- > C:/Ruby193/lib/ruby/site\_ruby/1.9.1/rubygems/custom\_require.rb:36:in > `require': cannot load such file -- mysql (LoadError) You say this same thing happens with any gem; that means your ruby/rubygems installation is broken. Unfortunately I have no idea how to troubleshoot that on Windows. You might try re-installing from scratch. Or just sidestep the pain and install a VM with some Linux distro. 🙂 Otherwise, perhaps someone with Windows experience will be able to suggest something. Sorry. > **···** > > On Sun, Nov 25, 2012 at 9:34 AM, john smith \ wrote: > > -- > Hassan Schroeder ------------------------ hassan.schroeder@gmail.com > > > **[Hassan Schroeder on about.me](https://about.me/hassanschroeder)** > > > > I use about.me to show people what matters most to me. > > twitter: @hassan ---
**Author:** ![Ivan\_Cenov](https://avatars.discourse-cdn.com/v4/letter/i/13edae/32.png) [@Ivan\_Cenov](https://rubytalk.org/u/Ivan_Cenov)\ **Post date:** [25 November 2012 18:53 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/9 "2012-11-25T18:53:39Z")
На 25.11.2012 г. 20:39 ч., john smith написа: > I just tried reinstalling ruby, i installed the devkit. i do have vmware > with ubuntu and bt5 that i could use, but im more comfortable with > windows. do you know of any other database that works well with ruby > that i could try? I don't understand Ruby, nevertheless I installed Redmine in our office. So, when we moved to Ruby 1.9.3 I had to use mysql2 gem, not mysql. My advice is to try mysql2. mysql2 requires newer version of libmysql.dll (6.0.2) > **···** > > -- > Regards, > > Ivan Cenov > OKTO-7 Co. Bulgaria > imc@okto7.com, i\_cenov@botevgrad.com > mobile:+359888761080, > phone:+35972366161, fax:+\_35972366262 ---
**Author:** ![Hassan\_Schroeder](https://yyz1.discourse-cdn.com/flex029/user_avatar/rubytalk.org/hassan_schroeder/32/1838_2.png) [@Hassan\_Schroeder](https://rubytalk.org/u/Hassan_Schroeder)\ **Post date:** [25 November 2012 19:13 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/10 "2012-11-25T19:13:12Z")
This has nothing whatsoever to do with a particular DB. MySQL with the mysql or mysql2 gem works fine "with ruby". It's the fact that your program can't find the gem in the first place that you need to address. > **···** > > On Sun, Nov 25, 2012 at 10:39 AM, john smith \ wrote: > > > I just tried reinstalling ruby, i installed the devkit. i do have vmware > > with ubuntu and bt5 that i could use, but im more comfortable with > > windows. do you know of any other database that works well with ruby > > that i could try? > > -- > Hassan Schroeder ------------------------ hassan.schroeder@gmail.com > > > **[Hassan Schroeder on about.me](https://about.me/hassanschroeder)** > > > > I use about.me to show people what matters most to me. > > twitter: @hassan ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [25 November 2012 20:25 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/11 "2012-11-25T20:25:01Z")
Ivan Cenov wrote in post #1086301: > На 25.11.2012 г. 20:39 ч., john smith написа: > > > I just tried reinstalling ruby, i installed the devkit. i do have vmware > > with ubuntu and bt5 that i could use, but im more comfortable with > > windows. do you know of any other database that works well with ruby > > that i could try? > > I don't understand Ruby, nevertheless I installed Redmine in our office. > So, > when we moved to Ruby 1.9.3 I had to use mysql2 gem, not mysql. My > advice is > to try mysql2. > mysql2 requires newer version of libmysql.dll (6.0.2) > > -- > Regards, > > Ivan Cenov > OKTO-7 Co. Bulgaria > imc@okto7.com, i\_cenov@botevgrad.com > mobile:+359888761080, > phone:+35972366161, fax:+\_35972366262 It was the libmysql.dll file, when you d/l the mysql 2.9.0 it said:   You've installed the binary version of mysql.   It was built using MySQL Connector/C version 6.0.2.   It's recommended to use the exact same version to avoid potential issues.   At the time of building this gem, the necessary DLL files where available   in the following URL:   [http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pi](http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pi) ck   You can put the lib\libmysql.dll available in this package to your Ruby bin directory.   E.g. C:\Ruby\bin Go to website unzip and place the libmysql.dll file in your ruby/bin folder. thanks for all the help > **···** > > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Eliezer\_Croitoru](https://avatars.discourse-cdn.com/v4/letter/e/6f9a4e/32.png) [@Eliezer\_Croitoru](https://rubytalk.org/u/Eliezer_Croitoru)\ **Post date:** [25 November 2012 22:56 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/12 "2012-11-25T22:56:44Z")
I would suggest you to install the rails installer since it's installing anything you need on windows. this link: [http://rubyforge.org/frs/download.php/75894/railsinstaller-2.1.0.exe](http://rubyforge.org/frs/download.php/75894/railsinstaller-2.1.0.exe) is not working for me couple days already so try this one: [http://ruby.taobao.org/mirrors/ruby/railsinstaller/railsinstaller-2.1.0.exe](http://ruby.taobao.org/mirrors/ruby/railsinstaller/railsinstaller-2.1.0.exe) Eliezer > **···** > > On 11/25/2012 10:25 PM, john smith wrote: > > > Ivan Cenov wrote in post #1086301: > > > > > На 25.11.2012 г. 20:39 ч., john smith написа: > > > > > > > I just tried reinstalling ruby, i installed the devkit. i do have vmware > > > > with ubuntu and bt5 that i could use, but im more comfortable with > > > > windows. do you know of any other database that works well with ruby > > > > that i could try? > > > > > > I don't understand Ruby, nevertheless I installed Redmine in our office. > > > So, > > > when we moved to Ruby 1.9.3 I had to use mysql2 gem, not mysql. My > > > advice is > > > to try mysql2. > > > mysql2 requires newer version of libmysql.dll (6.0.2) > > > > > > -- > > > Regards, > > > > > > Ivan Cenov > > > OKTO-7 Co. Bulgaria > > > imc@okto7.com, i\_cenov@botevgrad.com > > > mobile:+359888761080, > > > phone:+35972366161, fax:+\_35972366262 > > > > It was the libmysql.dll file, when you d/l the mysql 2.9.0 it said: > > > >    You've installed the binary version of mysql. > >    It was built using MySQL Connector/C version 6.0.2. > >    It's recommended to use the exact same version to avoid potential > > issues. > > > >    At the time of building this gem, the necessary DLL files where > > available > >    in the following URL: > > > >    [http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pi](http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pi) > > ck > > > >    You can put the lib\libmysql.dll available in this package to your > > Ruby bin directory. > >    E.g. C:\Ruby\bin > > > > Go to website unzip and place the libmysql.dll file in your ruby/bin > > folder. thanks for all the help > > -- > Eliezer Croitoru > [https://www1.ngtech.co.il](https://www1.ngtech.co.il) > sip:ngtech@sip2sip.info > IT consulting for Nonprofit organizations > eliezer \ ngtech.co.il ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [25 November 2012 23:14 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/13 "2012-11-25T23:14:58Z")
>   You can put the lib\libmysql.dll available in this package to your > Ruby bin directory. >   E.g. C:\Ruby\bin > > Go to website unzip and place the libmysql.dll file in your ruby/bin > folder. thanks for all the help Don't forget that you've got the RubyInstaller group as a resource if you're not getting decent windows specific answers here. Here's the search results with "mysql". [https://groups.google.com/forum/?fromgroups#!searchin/rubyinstaller/mysql](https://groups.google.com/forum/?fromgroups#!searchin/rubyinstaller/mysql) Also, briefly describe your system when posting. No one knew you were trying to use mysql on a windows system or your ruby version. Jon > **···** > > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![7stud2](https://avatars.discourse-cdn.com/v4/letter/7/9de053/32.png) [@7stud2](https://rubytalk.org/u/7stud2)\ **Post date:** [26 November 2012 00:26 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/14 "2012-11-26T00:26:12Z")
Jon Forums wrote in post #1086333: > >   You can put the lib\libmysql.dll available in this package to your > > Ruby bin directory. > >   E.g. C:\Ruby\bin > > > > Go to website unzip and place the libmysql.dll file in your ruby/bin > > folder. thanks for all the help > > Don't forget that you've got the RubyInstaller group as a resource if > you're not getting decent windows specific answers here. > > Here's the search results with "mysql". > > [Redirecting to Google Groups](https://groups.google.com/forum/?fromgroups#!searchin/rubyinstaller/mysql) > > Also, briefly describe your system when posting. No one knew you were > trying to use mysql on a windows system or your ruby version. > > Jon I will remember to mention my system and ruby version next time. thank you. > **···** > > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Travis\_Johnson1](https://avatars.discourse-cdn.com/v4/letter/t/59ef9b/32.png) [@Travis\_Johnson1](https://rubytalk.org/u/Travis_Johnson1)\ **Post date:** [26 November 2012 00:56 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/15 "2012-11-26T00:56:36Z")
Please unsubscribe me from this list. Thanks! > **···** > > On Nov 25, 2012, at 7:26 PM, john smith wrote: > > > Jon Forums wrote in post #1086333: > > > > > > You can put the lib\libmysql.dll available in this package to your > > > > Ruby bin directory. > > > > E.g. C:\Ruby\bin > > > > > > > > Go to website unzip and place the libmysql.dll file in your ruby/bin > > > > folder. thanks for all the help > > > > > > Don't forget that you've got the RubyInstaller group as a resource if > > > you're not getting decent windows specific answers here. > > > > > > Here's the search results with "mysql". > > > > > > [Redirecting to Google Groups](https://groups.google.com/forum/?fromgroups#!searchin/rubyinstaller/mysql) > > > > > > Also, briefly describe your system when posting. No one knew you were > > > trying to use mysql on a windows system or your ruby version. > > > > > > Jon > > > > I will remember to mention my system and ruby version next time. thank > > you. > > > > -- > > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Arlen\_Christian\_Mart](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@Arlen\_Christian\_Mart](https://rubytalk.org/u/Arlen_Christian_Mart)\ **Post date:** [26 November 2012 01:04 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/16 "2012-11-26T01:04:10Z")
Only you can do that: [Mailing Lists](http://www.ruby-lang.org/en/community/mailing-lists/#subscriptions-form) > **···** > > On Monday, 26 November 2012 at 11:56 AM, Travis Johnson wrote: > > > Please unsubscribe me from this list. Thanks! > > > > On Nov 25, 2012, at 7:26 PM, john smith wrote: > > > > \> Jon Forums wrote in post #1086333: > > \> \> \> You can put the lib\libmysql.dll available in this package to your > > \> \> \> Ruby bin directory. > > \> \> \> E.g. C:\Ruby\bin > > \> \> \> > > \> \> \> Go to website unzip and place the libmysql.dll file in your ruby/bin > > \> \> \> folder. thanks for all the help > > \> \> > > \> \> > > \> \> > > \> \> Don't forget that you've got the RubyInstaller group as a resource if > > \> \> you're not getting decent windows specific answers here. > > \> \> > > \> \> Here's the search results with "mysql". > > \> \> > > \> \> [Redirecting to Google Groups](https://groups.google.com/forum/?fromgroups#!searchin/rubyinstaller/mysql) > > \> \> > > \> \> Also, briefly describe your system when posting. No one knew you were > > \> \> trying to use mysql on a windows system or your ruby version. > > \> \> > > \> \> Jon > > \> > > \> I will remember to mention my system and ruby version next time. thank > > \> you. > > \> > > \> -- > > \> Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Travis\_Johnson1](https://avatars.discourse-cdn.com/v4/letter/t/59ef9b/32.png) [@Travis\_Johnson1](https://rubytalk.org/u/Travis_Johnson1)\ **Post date:** [26 November 2012 04:45 UTC](https://rubytalk.org/t/working-with-mysql-in-ruby/66739/17 "2012-11-26T04:45:28Z")
Thanks Arlen! Travis > **···** > > On Nov 25, 2012, at 8:04 PM, Arlen Cuss \ wrote: > > > Only you can do that: [Mailing Lists](http://www.ruby-lang.org/en/community/mailing-lists/#subscriptions-form) > > > > On Monday, 26 November 2012 at 11:56 AM, Travis Johnson wrote: > > > > > Please unsubscribe me from this list. Thanks! > > > > > > On Nov 25, 2012, at 7:26 PM, john smith wrote: > > > > > > > Jon Forums wrote in post #1086333: > > > > > > > > > > You can put the lib\libmysql.dll available in this package to your > > > > > > Ruby bin directory. > > > > > > E.g. C:\Ruby\bin > > > > > > > > > > > > Go to website unzip and place the libmysql.dll file in your ruby/bin > > > > > > folder. thanks for all the help > > > > > > > > > > Don't forget that you've got the RubyInstaller group as a resource if > > > > > you're not getting decent windows specific answers here. > > > > > > > > > > Here's the search results with "mysql". > > > > > > > > > > [Redirecting to Google Groups](https://groups.google.com/forum/?fromgroups#!searchin/rubyinstaller/mysql) > > > > > > > > > > Also, briefly describe your system when posting. No one knew you were > > > > > trying to use mysql on a windows system or your ruby version. > > > > > > > > > > Jon > > > > > > > > I will remember to mention my system and ruby version next time. thank > > > > you. > > > > > > > > -- > > > > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).