title: Rails db:create collation error
body: <p>I'm having an issue when running rake db:create:</p>
  
  <pre><code>[root@zephyrnode /domain/rails/testapp ]# rake db:create --trace
  (in /domain/rails/testapp)
  ** Invoke db:create (first_time)
  ** Invoke db:load_config (first_time)
  ** Invoke rails_env (first_time)
  ** Execute rails_env
  ** Execute db:load_config
  ** Execute db:create
  Couldn't create database for {"adapter"=&gt;"mysql", "encoding"=&gt;"utf8", "collation"=&gt;"utf8_bin", "reconnect"=&gt;false, "database"=&gt;"testapp_development", "pool"=&gt;5, "username"=&gt;"root", "password"=&gt;"rootpass", "socket"=&gt;"/var/run/mysqld/mysqld.sock", "host"=&gt;"127.0.0.1"}, charset: utf8, collation: utf8_bin (if you set the charset manually, make sure you have a matching collation)
  </code></pre>
  
  <p>I've attached all the possible version and settings info I can think of below.  I've tried all the solutions I found on google and have had no luck.  Does anyone have any solutions or suggestions?  Thanks!</p>
  
  <pre><code>[root@zephyrnode /domain/rails/testapp ]# mysql --version
  mysql  Ver 14.14 Distrib 5.1.38, for unknown-linux-gnu (x86_64) using  EditLine wrapper
  
  mysql&gt; show variables like "character_set_database";
  +------------------------+-------+
  | Variable_name          | Value |
  +------------------------+-------+
  | character_set_database | utf8  |
  +------------------------+-------+
  1 row in set (0.00 sec)
  
  mysql&gt; show variables like "collation_database";
  +--------------------+----------+
  | Variable_name      | Value    |
  +--------------------+----------+
  | collation_database | utf8_bin |
  +--------------------+----------+
  1 row in set (0.00 sec)
  
  [root@zephyrnode /domain/rails/testapp ]# ruby -v
  ruby 1.9.1p243 (2009-07-16 revision 24175) [x86_64-linux]
  
  [root@zephyrnode /domain/rails/testapp ]# rails -v
  Rails 2.3.4
  
  [root@zephyrnode /domain/rails/testapp ]# gem -v
  1.3.5
  
  [root@zephyrnode /domain/rails/testapp ]# gem list
  
  *** LOCAL GEMS ***
  
  actionmailer (2.3.4)
  actionpack (2.3.4)
  activerecord (2.3.4)
  activeresource (2.3.4)
  activesupport (2.3.4)
  cgi_multipart_eof_fix (2.5.0)
  daemons (1.0.10)
  fastthread (1.0.7)
  gem_plugin (0.2.3)
  mysql (2.8.1)
  rack (1.0.0)
  rails (2.3.4)
  rake (0.8.7)
  rubygems-update (1.3.5)
  </code></pre>
  
  <p>My database.yml:</p>
  
  <pre><code>development:
    adapter: mysql
    encoding: utf8
    collation: utf8_bin
    reconnect: false
    database: testapp_development
    pool: 5
    username: root
    password: rootpass
    socket: /var/run/mysqld/mysqld.sock
    host: 127.0.0.1
  </code></pre>