title: Error when running rake db:migrate
body: <p>I'm following the railscast where Ryan sets up a VPS. But I need to install mysql instead of postgresql.</p>
  
  <p>when I run the cap deploy:cold command, it all seems to run fine, until it runs the bundle, which fails when trying to install the mysql2 gem. </p>
  
  <p>so i logged into the server and installed it manually (the database had already been setup).</p>
  
  <p>but when i run the rake db:migrate command I keep getting this error:</p>
  
  <pre><code>rake aborted!
  database configuration does not specify adapter
  
  Tasks: TOP =&gt; db:migrate =&gt; db:load_config
  </code></pre>
  
  <p>in the database.yml file i have the following</p>
  
  <pre><code>production:
    adapter: mysql2
    encoding: utf8
    reconnect: false
    database: blog_production
    pool: 5
    username: blog
    password: *****
    host: localhost
    socket: /var/run/mysqld/mysqld.sock
  </code></pre>
  
  <p>I've edited the socket from default, added and removed the host line, and installed the gem manually, but nothing seems to make it work!</p>