i have installed mysql 5.5.11
and i'm running on Snow Leopard (10.6.7)
when i create my rails application everything wokrs fine:
rails fooTest -d mysql
then
cd fooTest
then
rake db:create
and i get:
Couldn't create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql", "database"=>"fooTest_development", "pool"=>5, "password"=>nil, "socket"=>"/tmp/mysql.sock"}, charset: utf8, collation: utf8_unicode_ci (if you set the charset manually, make sure you have a matching collation)
UPDATE mysql.user SET Password=OLD_PASSWORD('NewPassword') WHERE User='root'; FLUSH PRIVILEGES;