[Rails] Re: cannor rake db:create

Hey Dd Ss,

had the same problem a fews days ago. Unfortunately the error message
is a little bit misleading, because in that case it didn't had to do
anything with setting the charset manually. Anyway...

I'm assuming your working on a mac:
1. Make sure you refer the correct 'mysql.sock' file within your
database.yml. For a mac os x setup it usually should be '/tmp/
mysql.sock' not '/tmp/mysqld.sock' for example.
2. If that wasn't the problem, make sure to install the correct mysql
version with the right mysql gem accordingly. A good explanation for
doing this is given by Ian Selby at
http://stackoverflow.com/questions/991708/rails-mysql-and-snow-leopard/1349567#1349567

Cheers
Murphyslaw

On 4 Jul., 07:24, Dd Ss <li...@ruby-forum.com> wrote:
> I get this error message
>
>  denniss$ rake db:create
> (in /Users/denniss/Documents/RoR/blog)
> Couldn't create database for {"adapter"=>"mysql", "database"=>"blog",
> "encoding"=>"utf8", "pool"=>5, "username"=>"root",
> "password"=>"denniss",
> "socket"=>"/Applications/rubystack/mysql/tmp/mysql.sock"}, charset:
> utf8, collation: utf8_unicode_ci (if you set the charset manually, make
> sure you have a matching collation)
>
> note that I installed rubystack but I always use the ruby inside
>
> denniss$ which ruby
> /usr/local/bin/ruby
>
> denniss$ which mysql
> /Applications/rubystack/mysql/bin/mysql
> --
> Posted viahttp://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.