hi, i am new to the ruby on rails. i am trying to create one web application using ror, i created directory structure and started webrick server, after the when go for http://127.0.0.1:3000/, it gives the home page, after that i created one controller and rhtml file regarding that controller. but when i want to access that from the browser it gives the error like this "Access denied for user ''root''@''localhost'' (using password: NO)". can any bady just help me to rectify this problam. i am using rails 2.0.2 and mysql 5.0 versions. -- Posted via http://www.ruby-forum.com/.
Hi, That sounds like you haven''t set up your database.yml file correctly. Simon On Thu, 02 Jul 2009 20:11:33 +0800, Rajendra Bayana <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > hi, i am new to the ruby on rails. > > i am trying to create one web application using ror, i created directory > structure and started webrick server, after the when go for > http://127.0.0.1:3000/, it gives the home page, after that i created one > controller and rhtml file regarding that controller. > but when i want to access that from the browser it gives the error like > this "Access denied for user ''root''@''localhost'' (using password: NO)". > can any bady just help me to rectify this problam. i am using rails > 2.0.2 and mysql 5.0 versions.
On Thu, Jul 2, 2009 at 8:11 AM, Rajendra Bayana<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> "Access denied for user ''root''@''localhost'' (using password: NO)".This is coming from MySql. You need to set up config/database.yml to match your mysql setup. You can run mysql with no password for the root user, which is not advisable, but is often done in a DEVELOPMENT environment. It looks like your mysql setup requires a root user password. You can remove the password, if the machine is totally under your control, I can''t recall the details but a little googling should find them for you. The other alternative is to put the root mysql password in the config/database.yml file. The more normal setup is to create a mysql user for the Rails app, and give it access to only the databases and tables it needs. You really want to do something like this for the deployed production action. -- Rick DeNatale Blog: http://talklikeaduck.denhaven2.com/ Twitter: http://twitter.com/RickDeNatale WWR: http://www.workingwithrails.com/person/9021-rick-denatale LinkedIn: http://www.linkedin.com/in/rickdenatale