title: Can't connect rails 4 application with mysql database on digitalocean
body: <p>This application works perfectly fine in development mode  but i can't connect with database in production environment. i can access the mysql via <code>mysqld -u root -p</code> and same password works. I ll appreciate any help.</p>
  
  <p><strong>database.yml</strong></p>
  
  <pre><code>development:
    adapter: mysql2
    encoding: utf8
    pool: 5
    host: localhost
    database: rails_d
    username: root
    password: my_root_password
  
  test:
    adapter: mysql2
    encoding: utf8
    database: rails_t
    pool: 5
    username: root
    password: my_root_password
    host: localhost
  
  production:
    adapter: mysql2
    encoding: utf8
    pool: 5
    Host: localhost
    Database: rails
    Username: root
    Password: my_root_password
  </code></pre>
  
  <p><strong>production.log</strong></p>
  
  <pre><code>Mysql2::Error (Access denied for user 'root'@'localhost' (using password: NO)):
    mysql2 (0.3.13) lib/mysql2/client.rb:58:in `connect'
    mysql2 (0.3.13) lib/mysql2/client.rb:58:in `initialize'
    activerecord (4.0.0) lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `new'
    activerecord (4.0.0) lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `mysql2_connection'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout'
    /usr/local/rvm/rubies/ruby-1.9.3-p429/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
    /usr/local/rvm/rubies/ruby-1.9.3-p429/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection'
    activerecord (4.0.0) lib/active_record/connection_handling.rb:79:in `retrieve_connection'
    activerecord (4.0.0) lib/active_record/connection_handling.rb:53:in `connection'
    activerecord (4.0.0) lib/active_record/query_cache.rb:51:in `restore_query_cache_settings'
    activerecord (4.0.0) lib/active_record/query_cache.rb:43:in `rescue in call'
    activerecord (4.0.0) lib/active_record/query_cache.rb:32:in `call'
    activerecord (4.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:626:in `call'
    actionpack (4.0.0) lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
    activesupport (4.0.0) lib/active_support/callbacks.rb:373:in `_run__3934484784838772946__call__callbacks'
    activesupport (4.0.0) lib/active_support/callbacks.rb:80:in `run_callbacks'
    actionpack (4.0.0) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
    actionpack (4.0.0) lib/action_dispatch/middleware/remote_ip.rb:76:in `call'
    actionpack (4.0.0) lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'
    actionpack (4.0.0) lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'
    railties (4.0.0) lib/rails/rack/logger.rb:38:in `call_app'
    railties (4.0.0) lib/rails/rack/logger.rb:21:in `block in call'
    activesupport (4.0.0) lib/active_support/tagged_logging.rb:67:in `block in tagged'
    activesupport (4.0.0) lib/active_support/tagged_logging.rb:25:in `tagged'
    activesupport (4.0.0) lib/active_support/tagged_logging.rb:67:in `tagged'
    railties (4.0.0) lib/rails/rack/logger.rb:21:in `call'
    actionpack (4.0.0) lib/action_dispatch/middleware/request_id.rb:21:in `call'
    rack (1.5.2) lib/rack/methodoverride.rb:21:in `call'
    rack (1.5.2) lib/rack/runtime.rb:17:in `call'
    activesupport (4.0.0) lib/active_support/cache/strategy/local_cache.rb:83:in `call'
    actionpack (4.0.0) lib/action_dispatch/middleware/static.rb:64:in `call'
    railties (4.0.0) lib/rails/engine.rb:511:in `call'
    railties (4.0.0) lib/rails/application.rb:97:in `call'
    unicorn (4.6.3) lib/unicorn/http_server.rb:552:in `process_client'
    unicorn (4.6.3) lib/unicorn/http_server.rb:632:in `worker_loop'
    unicorn (4.6.3) lib/unicorn/http_server.rb:500:in `spawn_missing_workers'
    unicorn (4.6.3) lib/unicorn/http_server.rb:142:in `start'
    /usr/bin/unicorn:121:in `&lt;main&gt;'
  </code></pre>