# A Frustrated Beginner **URL:** \ **Category:** Rails\ **Created:** [October 6, 2007, 4:45am UTC](https://www.ruby-forum.com/t/a-frustrated-beginner/116500 "2007-10-06T04:45:50Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\ **Post date:** [October 6, 2007, 4:45am UTC](https://www.ruby-forum.com/t/a-frustrated-beginner/116500/1 "2007-10-06T04:45:50Z")
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. 😛 ---
**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\ **Post date:** [October 6, 2007, 6:32am UTC](https://www.ruby-forum.com/t/a-frustrated-beginner/116500/2 "2007-10-06T06:32:06Z")
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 ---
**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\ **Post date:** [October 6, 2007, 7:31am UTC](https://www.ruby-forum.com/t/a-frustrated-beginner/116500/3 "2007-10-06T07:31:45Z")
On 10/5/07, Mr. Watson [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) Date: Mar 28, 2006 9:55 AM Subject: Re: [Rails] I hope this is not spamming To: removed\_email\_address@domain.invalid Hi Julian, julian wrote: > so i type from the prompt > mysql depot\_development \ 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 ---
**Author:** ![MrSWatson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/46a35a/32.png) [@MrSWatson](https://www.ruby-forum.com/u/MrSWatson)\ **Post date:** [October 6, 2007, 4:24pm UTC](https://www.ruby-forum.com/t/a-frustrated-beginner/116500/4 "2007-10-06T16:24:22Z")
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.