Ruby Mysql Connection

Question

I setup ruby and mysql on my mac and i am having issues connecting to my local mysql server.

require 'rubygems'
require 'mysql'
...    
db = Mysql.new("localhost", "root", "", "")
...

This would give me the following error when i run this script fromt he command line:

generate.rb:37:in `initialize': wrong number of arguments (4 for 0) (ArgumentError)
from generate.rb:37:in `new'
from generate.rb:37

I have no idea why i am getting this error...any ideas?

Jonas Elfström · Accepted Answer · 2010-05-17 18:02:37Z

3

How about

db = Mysql.connect("localhost", "root", "", "")

?

answered May 17, 2010 at 18:02

Jonas Elfström

31.5k6 gold badges74 silver badges107 bronze badges

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

5 Comments

gprime Over a year ago

that gives: generate.rb:37: undefined method `connect' for Mysql:Class (NoMethodError)

Jonas Elfström Over a year ago

Hmm, I wonder what MySQL connector you are using. What does sudo gem spec mysql say?

gprime Over a year ago

lenny:script gprime$ sudo gem spec mysql Password: --- !ruby/object:Gem::Specification name: mysql version: !ruby/object:Gem::Version hash: 45 prerelease: false segments: - 2 - 8 - 1 version: 2.8.1 platform: ruby authors: - TOMITA Masahiro autorequire: bindir: bin cert_chain: [] ...

Jonas Elfström Over a year ago

That makes in even more strange because according to tmtm.org/en/mysql/ruby there really should be a connect method on Mysql.

Jonas Elfström Over a year ago

Also it seems Masahiro has moved to github github.com/tmtm/ruby-mysql#readme but it also seems lack english documentation.

Dmitry · Accepted Answer · 2011-02-08 18:08:07Z

1

reinstall mysql with command

sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- \
  --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib \
  --with-mysql-include=/usr/local/mysql/include

i've found the solution here http://thinlight.org/2010/05/12/how-to-install-ruby-mysql-on-mac-os-x-10-6-snow-leopard/

answered Feb 8, 2011 at 18:08

Dmitry

111 bronze badge

Comments

samaitra · Accepted Answer · 2012-03-18 14:57:14Z

1

I faced the same problem. Uninstalling mysql gem and installing ruby-mysql solved the issue.

sudo gem uninstall mysql

sudo gem install ruby-mysql

answered Mar 18, 2012 at 14:57

samaitra

7747 silver badges7 bronze badges

Comments

Casual Coder · Accepted Answer · 2010-05-17 18:08:55Z

0

You have clear message about wrong number of arguments to new method. Maybe try different method? real_connect for example.

db = Mysql.real_connect('localhost', 'test', 'test', 'testdb');

user: test, pass: test, db: testdb

answered May 17, 2010 at 18:08

Casual Coder

1,4922 gold badges14 silver badges15 bronze badges

2 Comments

gprime Over a year ago

nah, that did not work either generate.rb:37: undefined method `real_connect' for Mysql:Class (NoMethodError) maybe i should reinstall everything, seems like i am missing a lot of stuff

Casual Coder Over a year ago

require 'mysql' is passing so module is loaded, at least it seems that way. Odd. I tested that example and it worked for me (of course different credentials but it is irrelevant).

Collectives™ on Stack Overflow

Ruby Mysql Connection

4 Answers 4

5 Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related