mysql - Problem when I run my server on localhost (ruby on rails) -


when type rails server in cmd server works , can go localhost:3000. after messege in cmd , same message in browser on localhost:3000 in errors section.

started "/rails/info/properties" 127.0.0.1 @ 2010-12-02 21:14:55 +0200  mysql2::error (access denied user 'root'@'localhost' (using password: no)):  rendered c:/ruby192/lib/ruby/gems/1.9.1/gems/actionpack-3.0.3/lib/action_dispatc h/middleware/templates/rescues/_trace.erb (1.0ms) rendered c:/ruby192/lib/ruby/gems/1.9.1/gems/actionpack-3.0.3/lib/action_dispatc h/middleware/templates/rescues/_request_and_response.erb (30.0ms) rendered c:/ruby192/lib/ruby/gems/1.9.1/gems/actionpack-3.0.3/lib/action_dispatc h/middleware/templates/rescues/diagnostics.erb within rescues/layout (97.0ms) 

what issue?

here database.yml file:

# mysql. versions 4.1 , 5.0 recommended. # # install mysql driver: # gem install mysql2 # # , sure use new-style password hashing: # http://dev.mysql.com/doc/refman/5.0/en/old-client.html development: adapter: mysql2 encoding: utf8 reconnect: false database: simple_cms_development pool: 5 username: root password: host: localhost

# warning: database defined "test" erased , # re-generated development database when run 

"rake". # not set db same development or production. test: adapter: mysql2 encoding: utf8 reconnect: false database: simple_cms_test pool: 5 username: root password: host: localhost

production:   adapter: mysql2   encoding: utf8   reconnect: false   database: simple_cms_production   pool: 5   username: root   password:passwordex   host: localhost 

you're using root mysql user, not supplying root password in config/database.yml.

incidentally, while ok in development, using root mysql user in production or staging bad idea™.

here's typical mysql config section:

production:   adapter: mysql   database: app_production   username: root   password: password   pool: 5   timeout: 5000   encoding: utf8 

Comments

Popular posts from this blog

400 Bad Request on Apache/PHP AddHandler wrapper -

Add email recipient to all new Trac tickets -

php - Change action and image src url's with jQuery -