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-...
"
------------------------------------------------------------------------
Can anybody help me out?
Thanks in advance

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Search Discussions

  • Colin Law at Jan 6, 2012 at 12:12 pm

    On 5 January 2012 08:20, Pallav_bfs wrote:
    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
    This suggests that you have put a password in database.yml, but the
    error suggests there is no password. Is there a password in
    database.yml?

    Have you checked that you can access the database via mysql using root
    and whatever password is in this file?

    I *think* that you may need to restart the server if you change database.yml.

    Finally instantrails is very old, unless it has been recently updated.
    If you *must* do development on Windows then I think railsinstaller
    is currently recommended. Most would say that it is better to use Mac
    or Linux (I use Ubuntu). It is possible to do the development in a
    virtual machine such as vmware or virtualbox running Ubuntu on the
    windows host if you must use windows.

    Colin
    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-...
    --
    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@googlegroups.com.
    To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
    For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
  • Pallav_bfs at Feb 2, 2012 at 7:50 am
    Sorry for delayed response,Colin.
    Your advice helped and I fixed the error.
    Thanks !

    --
    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@googlegroups.com.
    To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
    For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
  • Norm Scherer at Jan 6, 2012 at 4:31 pm
    In a 'ruby console' window you can use the mysql commands. You should
    be able to do something like 'mysql -u root -ppassword library_development'
    If this does not work it means you have a missmatch between the password
    and what mysql has as the password.

    If that works you might look closely at the database.yml. It is picky
    about format and tabs cause problems.

    Can you access the database ok using MysqlAdmin?

    InstantRails works fine within its limitations. I use it all of the
    time for my limited purpose.

    Norm
    On 01/05/2012 01:20 AM, Pallav_bfs wrote:
    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-...
    "
    ------------------------------------------------------------------------
    Can anybody help me out?
    Thanks in advance
    --
    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@googlegroups.com.
    To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
    For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
  • Pallav_bfs at Feb 2, 2012 at 7:48 am
    Thanks Norm!
    I fixed the error.I used a wrong password in database.yml.
    And sorry for delayed response.
    Thanks for your response :)

    --
    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@googlegroups.com.
    To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
    For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouprubyonrails-talk @
categoriesrubyonrails
postedJan 6, '12 at 11:55a
activeFeb 2, '12 at 7:50a
posts5
users3
websiterubyonrails.org
irc#RubyOnRails

People

Translate

site design / logo © 2021 Grokbase