A Frustrated Beginner

I have tried everything in my power to get this program up and running
and it is not working for me. I have installed RoR on my Windows XP
machine. I have Instant Rails and Ruby on Rails and I am using Instant
Rails to connect the mySQL database to Ruby on Rails. It is not
working.

Everything works fine except when I try to sign into mySQL.
I enter my information: mysql -u root -p
Password: **************

This has been giving me fits. The error message says, "ERROR 1045
(280000): Access denied for user ‘ODBC’@‘localhost’ (using password:
NO). I have read up on this many times and I need someone that can
chat with me on an instant messenger or live chat to help me with my
problem, if possible.

After fixing this error I get others. I just want to get up and
running. :stuck_out_tongue:

Mr. Watson wrote:

I have tried everything in my power to get this program up and running
and it is not working for me. I have installed RoR on my Windows XP
machine. I have Instant Rails and Ruby on Rails and I am using Instant
Rails to connect the mySQL database to Ruby on Rails. It is not
working.

Everything works fine except when I try to sign into mySQL.
I enter my information: mysql -u root -p
Password: **************

This has been giving me fits. The error message says, "ERROR 1045
(280000): Access denied for user ‘ODBC’@‘localhost’ (using password:
NO). I have read up on this many times and I need someone that can
chat with me on an instant messenger or live chat to help me with my
problem, if possible.

After fixing this error I get others. I just want to get up and
running. :stuck_out_tongue:

I’m not familiar with Instant Rails, but are you sure the MySQL login
command isn’t…

mysql -u root --password=mypassword

Hope that helps a little at least.

E

On 10/5/07, Mr. Watson removed_email_[email protected] wrote:

This has been giving me fits. The error message says, "ERROR 1045
(280000): Access denied for user ‘ODBC’@‘localhost’ (using password:
NO). I have read up on this many times and I need someone that can
chat with me on an instant messenger or live chat to help me with my
problem, if possible.

After fixing this error I get others. I just want to get up and
running. :stuck_out_tongue:

This seems to happen to some people on Windows but not others…
really don’t know why.

But Bill W. figured out a solution. Here’s one of his old emails
where he explained.

Curt

---------- Forwarded message ----------
From: Bill W. [email protected]
Date: Mar 28, 2006 9:55 AM
Subject: Re: [Rails] I hope this is not spamming
To: [email protected]

Hi Julian,

julian wrote:

so i type from the prompt
mysql depot_development <db/create.sql return
depot_development is the the database I want to
put the table into, and it was created previously by me.
I get back:
ERROR: 1045 <28000>: Access denied for user
‘ODBC’@‘localhost’

The fix is to grant the user “ODBC” access rights to the database. The
way
you do this is as follows.

  1. log in to mySQL as root. Open a Command Window, cd to the app
    directory
    (probably ‘depot’ in your case), and enter:
    mysql -u root -p
    Then just hit enter when prompted for the root password, or enter one if
    you’ve set one up for the root user.

  2. enter the following line to grant access to the “ODBC” user
    grant all on depot_development.* to ‘ODBC’@‘localhost’;

  3. enter the following line to exit
    exit

The only other thing I see that may be contributing to your problem is
the
‘using password: NO’ part of the error message. If you still get the
error
message after making the change above, you may need to change the
password
field in your database.yml file. I just leave it blank for development
on
my desktop.

HTH,
Bill

Just leave your password blank by hitting the Enter key when
prompted. I bet you are not using a password for root in MySQL. Do
the same thing for database.yml. It is not a big deal to leave out
the password for development. In production, you should have one.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs