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
Post a Comment