Hi, I''m new to RoR, just trying to get my environment set up. I am following the tutorial at: http://instantrails.rubyforge.org/tutorial/. When I point my browser to http://localhost:3000/recipe/list, the following error appears in the browser: Mysql::Error in RecipeController#list Access denied for user ''root''@''localhost'' (using password: NO) I had this problem before and figured it had to do with privileges. I re-installed InstantRails (in a different directory) after being added to the Administrators group on my computer. The problem still occurs. Any ideas? Now I think it might be an issue with port numbers, but I''m not sure how to track it down. Thanks, R
Can you run the cookbook app that came preinstalled with Instant Rails? It looks like MySQL is expecting a password for the "root" user even though it should be blank. Have you changes the "root" user password in the database? Try unzipping a fesh copy of Instant Rails into a brand new directory, then start it up and try running the included cookbook app and see if it works. Curt On 6/29/06, Randee Bierlein <rbierlein at gmail.com> wrote:> > Hi, > > I''m new to RoR, just trying to get my environment set up. I am > following the tutorial at: > http://instantrails.rubyforge.org/tutorial/. When I point my browser > to http://localhost:3000/recipe/list, the following error appears in > the browser: > > Mysql::Error in RecipeController#list > Access denied for user ''root''@''localhost'' (using password: NO) > > I had this problem before and figured it had to do with privileges. I > re-installed InstantRails (in a different directory) after being added > to the Administrators group on my computer. The problem still occurs. > > Any ideas? Now I think it might be an issue with port numbers, but > I''m not sure how to track it down. > > Thanks, > > R > _______________________________________________ > Instantrails-users mailing list > Instantrails-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instantrails-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20060629/84565566/attachment.html
Hi Curt, Thanks for the reply. Yes, I am working with the cookbook application that came with the installation. I''ve unzipped fresh copies of InstantRails into new directories a few times now and I always get this problem. No, I haven''t changed the password for ''root'' in the database. I just checked cookbook/config/database.yml to be sure: the password is blank. I do get an error when I start InstantRails.exe: MySQL port (3306) is in use. Is that a problem? Thanks, R On 6/29/06, Curt Hibbs <curt.hibbs at gmail.com> wrote:> Can you run the cookbook app that came preinstalled with Instant Rails? > > It looks like MySQL is expecting a password for the "root" user even though > it should be blank. Have you changes the "root" user password in the > database? > > Try unzipping a fesh copy of Instant Rails into a brand new directory, then > start it up and try running the included cookbook app and see if it works. > > Curt > > > On 6/29/06, Randee Bierlein <rbierlein at gmail.com> wrote: > > > Hi, > > I''m new to RoR, just trying to get my environment set up. I am > following the tutorial at: > http://instantrails.rubyforge.org/tutorial/. When I point > my browser > to http://localhost:3000/recipe/list, the following error > appears in > the browser: > > Mysql::Error in RecipeController#list > Access denied for user ''root''@''localhost'' (using password: NO) > > I had this problem before and figured it had to do with privileges. I > re-installed InstantRails (in a different directory) after being added > to the Administrators group on my computer. The problem still occurs. > > Any ideas? Now I think it might be an issue with port numbers, but > I''m not sure how to track it down. > > Thanks, > > R > _______________________________________________ > Instantrails-users mailing list > Instantrails-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instantrails-users > > > _______________________________________________ > Instantrails-users mailing list > Instantrails-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instantrails-users > >
William (Bill) Froelich
2006-Jun-29 21:32 UTC
[Instantrails-users] Unable to run cookbook example
> -----Original Message----- > From: instantrails-users-bounces at rubyforge.org > [mailto:instantrails-users-bounces at rubyforge.org] On Behalf > Of Randee Bierlein > Sent: Thursday, June 29, 2006 4:05 PM > To: curt at hibbs.com; instantrails-users at rubyforge.org > Subject: Re: [Instantrails-users] Unable to run cookbook example > > Hi Curt, > > Thanks for the reply. Yes, I am working with the cookbook > application that came with the installation. I''ve unzipped > fresh copies of InstantRails into new directories a few times > now and I always get this problem. > > No, I haven''t changed the password for ''root'' in the > database. I just checked cookbook/config/database.yml to be > sure: the password is blank. > > I do get an error when I start InstantRails.exe: MySQL port > (3306) is in use. Is that a problem?I would guess that you already have a copy of MySQL running on your machine and when InstantRails starts its copy it fails because the port is already in use. That would explain why you got the error about the root password. The instance already on your machine is setup with a root password while the database.yml doesn''t have one defined. You will probably need to change the port that the MySQL under instantrails uses. Unfortunately I am not sure quite how to do this. I did some quick checking and don''t have a ready answer for you. Maybe someone else can jump in or I''ll try again later tonight. Hope this helps! --Bill
On 6/29/06, William (Bill) Froelich <wfroelich at dbsnow.com> wrote:> > > -----Original Message----- > > From: instantrails-users-bounces at rubyforge.org > > [mailto:instantrails-users-bounces at rubyforge.org] On Behalf > > Of Randee Bierlein > > Sent: Thursday, June 29, 2006 4:05 PM > > To: curt at hibbs.com; instantrails-users at rubyforge.org > > Subject: Re: [Instantrails-users] Unable to run cookbook example > > > > Hi Curt, > > > > Thanks for the reply. Yes, I am working with the cookbook > > application that came with the installation. I''ve unzipped > > fresh copies of InstantRails into new directories a few times > > now and I always get this problem. > > > > No, I haven''t changed the password for ''root'' in the > > database. I just checked cookbook/config/database.yml to be > > sure: the password is blank. > > > > I do get an error when I start InstantRails.exe: MySQL port > > (3306) is in use. Is that a problem? > > I would guess that you already have a copy of MySQL running on your > machine and when InstantRails starts its copy it fails because the port > is already in use. That would explain why you got the error about the > root password. The instance already on your machine is setup with a > root password while the database.yml doesn''t have one defined. > > > You will probably need to change the port that the MySQL under > instantrails uses. Unfortunately I am not sure quite how to do this. I > did some quick checking and don''t have a ready answer for you. Maybe > someone else can jump in or I''ll try again later tonight. > > Hope this helps! > > --Bill > _______________________________________________ >Yes, Bill is right. You have another, conflicting instance of MySQL already running. If you were unaware of that, then perhaps you don''t need to other copy of MySQL and you could just uninstall it. In any case, just try shutting down the other Instant of MySQL before starting Instant Rails to verify that everything else is ok. Curt -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20060629/f5443df2/attachment.html