Forum: Ruby on Rails mySQL: ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO)

138974e3b32308360e8f4653f5776407?d=identicon&s=25 Pallav_bfs (Guest)
on 2012-01-06 12:57
(Received via mailing list)
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-...
"
5f94b9b346c2aa648a80bc259978e5bc?d=identicon&s=25 Colin Law (Guest)
on 2012-01-06 13:13
(Received via mailing list)
On 5 January 2012 08:20, Pallav_bfs <spallav88@gmail.com> wrote:
> #  gem install mysql
> #    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
46f52c33235283752423837b91c581dd?d=identicon&s=25 Norm Scherer (Guest)
on 2012-01-06 17:32
(Received via mailing list)
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
138974e3b32308360e8f4653f5776407?d=identicon&s=25 Pallav_bfs (Guest)
on 2012-02-02 08:49
(Received via mailing list)
Thanks Norm!
I fixed the error.I used a wrong password in database.yml.
And sorry for delayed response.
Thanks for your response :)
138974e3b32308360e8f4653f5776407?d=identicon&s=25 Pallav_bfs (Guest)
on 2012-02-02 08:51
(Received via mailing list)
Sorry for delayed response,Colin.
Your advice helped and I fixed the error.
Thanks !
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.