Hello, I am using InstantRails 2.0 on windows.
When building an app,I get this error when hit the browser(Action
ControllerException caught):
Access denied for user ‘root’@‘localhost’ (using password: NO)
The database.yml file is configured like this:
MySQL. Versions 4.1 and 5.0 are recommended.
Install the MySQL driver:
gem install mysql
On Mac OS X:
sudo gem install mysql – --with-mysql-dir=/usr/local/mysql
On Mac OS X Leopard:
sudo env ARCHFLAGS=“-arch i386” gem install mysql – --with-mysql-
config=/usr/local/mysql/bin/mysql_config
This sets the ARCHFLAGS environment variable to your native
architecture
On Windows:
gem install mysql
Choose the win32 build.
Install MySQL and put its /bin directory on your path.
And be sure to use new-style password hashing:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
adapter: mysql
encoding: utf8
database: library_development
username: root
password: password
host: localhost
Warning: The database defined as ‘test’ will be erased and
re-generated from your development database when you run ‘rake’.
Do not set this db to the same as development or production.
test:
adapter: mysql
encoding: utf8
database: library_test
username: root
password: password
host: localhost
production:
adapter: mysql
encoding: utf8
database: library_production
username: root
password: password
host: localhost
The development log is showing like this
"
Rendering C:/InstantRails-2.0-win/ruby/lib/ruby/gems/1.8/gems/
actionpack-2.0.2/lib/action_controller/templates/rescues/layout.erb
(internal_server_error)
Processing BookController#index (for 127.0.0.1 at 2012-01-05 13:22:31)
[GET]
Session ID:
BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo
%0ASGFzaHsABjoKQHVzZWR7AA%3D%3D–
d8a35d2303977ea5f70494b175549ff7959c5ee9
Parameters: {“action”=>“index”, “controller”=>“book”}
Mysql::Error (Access denied for user ‘root’@‘localhost’ (using
password: NO)):
C:/InstantRails-2.0-win/ruby/lib/ruby/gems/1.8/gems/
activerecord-2.0.2/lib/active_record/connection_adapters/
mysql_adapter.rb:471:in real_connect' C:/InstantRails-2.0-win/ruby/lib/ruby/gems/1.8/gems/ activerecord-2.0.2/lib/active_record/connection_adapters/ mysql_adapter.rb:471:in
connect’
C:/InstantRails-2.0-win/ruby/lib/ruby/gems/1.8/gems/
activerecord-…
"