Rails Development- MySQL Connection Problems

Question

I'm new in Rails. I tried a lot to solve my problem with the answers given in this site, but failed.

1.My configurations

Window 7 64bit
ruby 1.9.3p484
rails 4.0.2
mysql server 5.0.91-community-nt (32bit)
mysql gem
I set a password for root in mysql configuration

2.I created a new application
rails new my_cms -d mysql
I made two changes
1. Inside Gemfile I use mysql instead of mysql2
2. Inside config/database.yml I use mysql instead of mysql2

3. config/database.yml content

development:
  adapter: mysql  
  encoding: utf8  
  database: mycms_development  
  pool: 5  
  username: root  
  password:  
  host: 127.0.0.1  
  port: 3306

test:
  adapter: mysql2  
  encoding: utf8  
  database: mycms_test  
  pool: 5  
  username: root  
  password:  
  host: localhost

production:
  adapter: mysql2  
  encoding: utf8  
  database: mycms_production  
  pool: 5  
  username: root  
  password:  
  host: localhost

4.Running server
rails s
server running.
5.opening browser and typing localhost:3000ERROR like below

Mysql::Error
Access denied for user 'root'@'localhost' (using password: NO)
Rails.root: E:/cms/mycms

6.My efforts to solve the error
I tried my best to crack the error as guided here.
TRY=> changed 127.0.0.1 instead of localhost, added port: 3306
RESULT=> Mysql::Error
Access denied for user 'root'@'localhost' (using password: NO)
Rails.root: E:/cms/mycms

TRY=> put my password as root password field inside config/database.yml file
RESULT=>ActiveRecord::ConnectionNotEstablished

TRY=> executed mysql -uroot
RESULT=> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

TRY=> Created a new user vipin and grant all privileges and executed mysql -uvipin
RESULT=> ERROR 1045 (28000): Access denied for user 'vipin'@'localhost' (using password: NO)

TRY=> executed mysql -uroot -p
RESULT=> password: and when i gave the password it successfully direct to mysql> prompt.

I dont know what is next. Please help. Thank you

EDIT
CURRENT STATUS WHEN ENTERING localhost:3000

Answer 1

Try going into mysql -u root and doing `GRANT ALL PRIVILEGES ON mycms_development.* TO root@localhost

Answer 2

Try to set password and host for test environment too:

development:
  adapter: mysql  
  encoding: utf8  
  database: mycms_development  
  pool: 5  
  username: root  
  password: vipin 
  host: localhost  
  port: 3306

test:
  adapter: mysql  
  encoding: utf8  
  database: mycms_test  
  pool: 5  
  username: root  
  password: vipin
  host: localhost
  port: 3306

production:
  adapter: mysql  
  encoding: utf8  
  database: mycms_production  
  pool: 5  
  username: root  
  password:  
  host: localhost
  port: 3306

If doesn't work try host: 127.0.0.1

Anyway I recommend to to use MySQL 5.5 and the mysql2 gem. to install that gem have a look this link.

Or you can try BitMani Ruby Stack Installer for windows.

Ruby Stack Installer

BitMani wiki