Vasanthakumar Csk
2006-Dec-14 06:52 UTC
Access denied for user ''root''@''localhost'' using password:NO
Hi Everyone,
I developed an application in my system with Ruby, Rails,
WEBrick and MySQL - everything installed in my system.
First, i got this error
"Access denied for user
''root''@''localhost'' using password:NO"
But i found a quick fix, by installing MySQL without password and
user name as "root". And everything went fine.
Now, my problem is - i want to upload my application and host it on
net. But am getting the same error. Dont know how to fix it, i cant
re-install mysql without password (will lead to security issue) or
restart the ''Apache'' server etc... since i read somewhere that
if we
change the "database.yml" file we should restart the Web Server
(infact
i was doing this in my system - restarting the WEBrick server)
Please anyone help me hosting my application.
Thanks in advance
Regards,
Vasanth
--
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
-~----------~----~----~----~------~----~------~--~---
Guest
2006-Dec-14 07:01 UTC
Re: Access denied for user ''root''@''localhost'' using password
have u updated the database.yml with u r database name and password? change it. -- 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 -~----------~----~----~----~------~----~------~--~---
Vasanthakumar Csk
2006-Dec-14 07:02 UTC
Re: Access denied for user ''root''@''localhost'' using password
Ya i have made all the changes in "database.yml" file... Still getting the same error :-( -- 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 -~----------~----~----~----~------~----~------~--~---
Conrad Taylor
2006-Dec-14 09:45 UTC
Re: Access denied for user ''root''@''localhost'' using password
Hi, is the database and database.yml have the exact same userid and pass for access? -Conrad On 12/13/06, Vasanthakumar Csk <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Ya i have made all the changes in "database.yml" file... > Still getting the same error :-( > > > -- > 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 -~----------~----~----~----~------~----~------~--~---
Vasanthakumar Csk
2006-Dec-14 10:51 UTC
Re: Access denied for user ''root''@''localhost'' using password
Ya both the database and database.yml have the exact userid and password.... But i read somewhere that the Webserver should be restarted to take effect. Here in my case, thats impossible bcaz we have to host the application somewhere else. They wont restart the "Apache" server for our purpose... since many application are running there... If restarting the Webserver is the problem, then can anyone tell me another way to resolve this?? -- 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 -~----------~----~----~----~------~----~------~--~---
Carolene
2006-Dec-14 11:29 UTC
Re: Access denied for user ''root''@''localhost'' using password
Try to check whether u given password as NO??? development: adapter: mysql database: ubac_webfront_development username: root password: host: localhost check it to look like as above and then restart your webrick server. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Luke
2006-Dec-14 12:03 UTC
Re: Access denied for user ''root''@''localhost'' using password
Kiran Soumya wrote:> Try to check whether u given password as NO??? > > development: > adapter: mysql > database: ubac_webfront_development > username: root > password: > host: localhost > > check it to look like as above and then restart your webrick server.I''m assuming you have the database.yml production settings filled in? production: adapter: mysql database: production_database_name username: production_user_name password: production_password host: localhost If you are getting the same message are you running your application in production mode? You might want to uncomment in the line in config/environment.rb: # ENV[''RAILS_ENV''] = ''production'' So it reads ENV[''RAILS_ENV''] = ''production'' -- 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 -~----------~----~----~----~------~----~------~--~---
Vasanthakumar Csk
2006-Dec-14 12:31 UTC
Re: Access denied for user ''root''@''localhost'' using password
Ya everything is fine and good.... But still the problem exists :-( do i need to restart "Apache" webserver?? -- 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 -~----------~----~----~----~------~----~------~--~---
Luke
2006-Dec-14 12:52 UTC
Re: Access denied for user ''root''@''localhost'' using password
Vasanthakumar Csk wrote:> Ya everything is fine and good.... > But still the problem exists :-( > do i need to restart "Apache" webserver??You should be able to just restart your fcgi processes - check out reaper.rb in the rails scripts directory. -- 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 -~----------~----~----~----~------~----~------~--~---