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
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.
---------- 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]
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
The fix is to grant the user “ODBC” access rights to the database. The
you do this is as follows.
log in to mySQL as root. Open a Command Window, cd to the app
(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
The only other thing I see that may be contributing to your problem is
‘using password: NO’ part of the error message. If you still get the
message after making the change above, you may need to change the
field in your database.yml file. I just leave it blank for development