# Cannor rake db:create

**URL:** <https://www.ruby-forum.com/t/cannor-rake-db-create/191072>\
**Category:** Rails\
**Created:** [July 4, 2010, 7:24am UTC](https://www.ruby-forum.com/t/cannor-rake-db-create/191072 "2010-07-04T07:24:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![denniss](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ec9cab/32.png) [@denniss](https://www.ruby-forum.com/u/denniss)\
**Post date:** [July 4, 2010, 7:24am UTC](https://www.ruby-forum.com/t/cannor-rake-db-create/191072/1 "2010-07-04T07:24:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![denniss](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ec9cab/32.png) [@denniss](https://www.ruby-forum.com/u/denniss)\
**Post date:** [July 4, 2010, 11:12am UTC](https://www.ruby-forum.com/t/cannor-rake-db-create/191072/2 "2010-07-04T11:12:30Z")

</div>

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  
[Rails, MySQL and Snow Leopard - Stack Overflow](http://stackoverflow.com/questions/991708/rails-mysql-and-snow-leopard/1349567#1349567)

Cheers  
Murphyslaw