Ruby MySQL access problem

[harkerboy]

I've got the following code seems runnable. it just performs like building a connection with a configurable username and password.

# dbConn.rb

require "mysql"

begin

dbname="aDatabase"
print "Please enter your user name associating with mysql DB: "
uName= gets
print "Please enter your password: "
pwd= gets

m = Mysql.real_connect("localhost",uName,pwd)
m.select_db(dbname)
result = m.query("SELECT * FROM content")

m.close
end

But when I attempt to run it, it returns Access denied as shown below. Anyone got idea on why?

george@linux:~/updating> ruby dbConn.rb
Please enter your user name associating with mysql DB: root
Please enter your password: xxxxxx
dbConn.rb:14:in `real_connect': Access denied for user: 'root (Mysql::Error)
@localhost' (Using password: YES) from dbConn.rb:14

[xmitchx]

When you call "gets" make you sure you call "gets.chomp" because it includes the newline in it.

[harkerboy]

I've just tried it out, and it is exactly the point!! Thanks for your comment!

[bfsog]

Sorry to hijack the thread, I just installed Mysql 5.0.2 and I am running 1.8.4 stable of Ruby.

I am just messing around, seeing what can be done,

I tried to connect to mysql through a ruby file but I get this error.

no such file to load - mysql (LoadError)

mysql is installed at C:\Program Files\MySQL
ruby is installed at C:\ruby
the file is located at C:\ruby\programs\mysqlconn.rb

Cheers

[xmitchx]

You have to install the mysql gem:

gem install mysql

[bfsog]

I tried that.. and got:

undefined local variable or method 'mysql' for main: Object (NameError)

http://www.tmtm.org/en/mysql/ - I tried to install this but when I run extconf.rb it doesnt follow through, not sure what path to put after?