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. 
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. 
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 [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. 
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.
-
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.
-
enter the following line to grant access to the “ODBC” user
grant all on depot_development.* to ‘ODBC’@‘localhost’;
-
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.
