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?

Answer 1

How about

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

?

Answer 2

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