I am new for MySQL and Ruby.

require 'rubygems'
require 'mysql'
# Connect to a MySQL database 'test' on the local machine
# using username of 'root' with no password.
db = Mysql.connect('localhost', 'root', '', 'test')
# Perform an arbitrary SQL query
db.query("INSERT INTO people (name, age) VALUES('Chris', 25)")
# Perform a query that returns data
begin
query = db.query('SELECT * FROM people')
puts "There were #{query.num_rows} rows returned"
query.each_hash do |h|
puts h.inspect
end
rescue
puts db.errno
puts db.error
end
# Close the connection cleanly
db.close

When I try to run above program, I got error like following:

mysql.rb:6:in `connect': Access denied for user 'root'@'localhost'
(using

password: NO) (Mysql::Error)

from mysql.rb:6:in `<main>'

 How can I able to solve this error?

Could anyone one help me in this?

Thank you.

-- 
Posted via http://www.ruby-forum.com/.