Couldn't able to solve MySQL error

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 `’

How can I able to solve this error?

Could anyone one help me in this?

Thank you.

On Wed, Mar 5, 2014 at 4:05 PM, Jaimin P. [email protected]
wrote:

I am new for MySQL and Ruby.

require ‘rubygems’

With current Ruby versions the line above should not be necessary.

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’)

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 `’

How can I able to solve this error?

Can you access the database with these credentials with the MySQL
command line tool? If not you need to use proper credentials that you
have set up your database with. If you can something with your Ruby
setup seems to be broken.

Cheers

robert

Can you access the database with these credentials with the MySQL
command line tool? If not you need to use proper credentials that you
have set up your database with. If you can something with your Ruby
setup seems to be broken.

Cheers

robert

I am trying to access the database with these credentials with the MYSQL
command line tool.

Thank you.