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.