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. :-P --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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. :-PI''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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 10/5/07, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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. :-PThis seems to happen to some people on Windows but not others... really don''t know why. But Bill Walton figured out a solution. Here''s one of his old emails where he explained. Curt ---------- Forwarded message ---------- From: Bill Walton <bill.walton-xwVYE8SWAR3R7s880joybQ@public.gmane.org> Date: Mar 28, 2006 9:55 AM Subject: Re: [Rails] I hope this is not spamming To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Hi Julian, julian wrote: <snip>> 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'' <using password: NO>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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 create a scaffold it gives me an error in mySQL. The error reads, "> ruby script/generate scaffold Product Admin exists app/controllers/ exists app/helpers/ exists app/views/admin exists app/views/layout exists test/functional/ dependency model exists app/models/ exists test/unit/ exists test/fixtures/ identical app/models/product.rb identical test/unit/products.ywl identical test/fixtures/product.yml #28000Access denied for user ''root''@''localhost'' (using password: NO)". I have done this several time and continue to get the same error. Is there anyone that can chat with me on an instant messenger or live chat to help me with my problem, if possible. My config/database.yml files shows, # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Install the MySQL driver: # gem install mysql # On MacOS X: # gem install mysql -- --include=/usr/local/lib # On Windows: # gem install mysql # Choose the win32 build. # Install MySQL and put its /bin directory on your path. # # And be sure to use new-style password hashing: # http://dev.mysql.com/doc/refman/5.0/en/old-client.html development: adapter: mysql database: depot_development username: root password: host: localhost # Warning: The database defined as ''test'' will be erased and # re-generated from your development database when you run ''rake''. # Do not set this db to the same as development or production. test: adapter: mysql database: depot_test username: root password: host: localhost production: adapter: mysql database: depot_production username: root password: host: localhost It seems to be correct to me. Any ideas? Is there anyone I can chat with real time about this? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
It was the password thing. Bharat was correct. Thank you. On Oct 6, 11:45 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 create a scaffold it gives me an > error in mySQL. > The error reads, > > "> ruby script/generate scaffold Product Admin > exists app/controllers/ > exists app/helpers/ > exists app/views/admin > exists app/views/layout > exists test/functional/ > dependency model > exists app/models/ > exists test/unit/ > exists test/fixtures/ > identical app/models/product.rb > identical test/unit/products.ywl > identical test/fixtures/product.yml > #28000Access denied for user ''root''@''localhost'' (using password: NO)". > > I have done this several time and continue to get the same error. Is > there anyone that can chat with me on an instant messenger or live > chat to help me with my problem, if possible. > > My config/database.yml files shows, > > # MySQL (default setup). Versions 4.1 and 5.0 are recommended. > # > # Install the MySQL driver: > # gem install mysql > # On MacOS X: > # gem install mysql -- --include=/usr/local/lib > # On Windows: > # gem install mysql > # Choose the win32 build. > # Install MySQL and put its /bin directory on your path. > # > # And be sure to use new-style password hashing: > # http://dev.mysql.com/doc/refman/5.0/en/old-client.html > development: > adapter: mysql > database: depot_development > username: root > password: > host: localhost > > # Warning: The database defined as ''test'' will be erased and > # re-generated from your development database when you run ''rake''. > # Do not set this db to the same as development or production. > test: > adapter: mysql > database: depot_test > username: root > password: > host: localhost > > production: > adapter: mysql > database: depot_production > username: root > password: > host: localhost > > It seems to be correct to me. > > Any ideas? Is there anyone I can chat with real time about this?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---