# Mysql rake functions failing

**URL:** <https://www.ruby-forum.com/t/mysql-rake-functions-failing/178705>\
**Category:** Rails\
**Created:** [November 9, 2009, 7:57pm UTC](https://www.ruby-forum.com/t/mysql-rake-functions-failing/178705 "2009-11-09T19:57:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/eada6e/32.png) [@dan](https://www.ruby-forum.com/u/dan)\
**Post date:** [November 9, 2009, 7:57pm UTC](https://www.ruby-forum.com/t/mysql-rake-functions-failing/178705/1 "2009-11-09T19:57:38Z")

</div>

im new to mac and ruby but have been through some tutorials using  
sqlite  
ive downloaded a plugin for geolocation and it needs mysql for  
advanced functionality  
however whenever i try to run the rake commads with mysql adapter, i  
get errors

i created the ruby app using the -d mysql command  
my database.yml looks as follows

development:  
adapter: mysql  
encoding: utf8  
reconnect: false  
database: geokit\_v1  
pool: 5  
username: root  
password: \*\*\*\* # hiddne root password  
socket: /tmp/mysql.sock

rake db:create yields

Couldn’t create database for {“reconnect”=\>false, “encoding”=\>“utf8”,  
“username”=\>“root”, “adapter”=\>“mysql”, “database”=\>“geokit\_v1”,  
“pool”=\>5, “password”=\>’\*\*\*’, “socket”=\>"/tmp/mysql.sock"}, charset:  
utf8, collation: utf8\_general\_ci (if you set the charset manually,  
make sure you have a matching collation)

some posts about this topic say the charset may be misleading  
yet in mysql if i see this  
`
mysql> show variables like ‘char%’;
±-------------------------
±-------------------------------------------------------+
| Variable_name |
Value |
±-------------------------
±-------------------------------------------------------+
| character_set_client |
latin1 |
| character_set_connection |
latin1 |
| character_set_database |
latin1 |
| character_set_filesystem |
binary |
| character_set_results |
latin1 |
| character_set_server |
latin1 |
| character_set_system |
utf8 |
| character_sets_dir | /usr/local/mysql-5.1.40-osx10.5-x86_64/
share/charsets/ |
±-------------------------
±-------------------------------------------------------+
8 rows in set (0.00 sec)
`

rails 2.3.3  
ruby 1.8.7  
Server version: 5.1.40 MySQL Community Server (GPL)

this is super annoying  
it has been for the whole weekend

please help

---

<div class="post-metadata">

**Author:** ![dan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/eada6e/32.png) [@dan](https://www.ruby-forum.com/u/dan)\
**Post date:** [November 9, 2009, 8:12pm UTC](https://www.ruby-forum.com/t/mysql-rake-functions-failing/178705/2 "2009-11-09T20:12:16Z")

</div>

dan wrote:

> Couldn’t create database for {“reconnect”=\>false, “encoding”=\>“utf8”,  
> “username”=\>“root”, “adapter”=\>“mysql”, “database”=\>“geokit\_v1”,  
> “pool”=\>5, “password”=\>’\*\*\*’, “socket”=\>"/tmp/mysql.sock"}, charset:  
> utf8, collation: utf8\_general\_ci (if you set the charset manually,  
> make sure you have a matching collation)

When you installed MySQL, you were presented with a screen asking your  
for character set information. Do you remember what you chose? I never  
specify my charset within the config file (I am not sure if this is  
correct or not)

You can change the default char set through the MySQLAdmin tool and need  
not worry when connecting with AR.

hth

ilan

---

<div class="post-metadata">

**Author:** ![dan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/eada6e/32.png) [@dan](https://www.ruby-forum.com/u/dan)\
**Post date:** [November 9, 2009, 8:47pm UTC](https://www.ruby-forum.com/t/mysql-rake-functions-failing/178705/3 "2009-11-09T20:47:24Z")

</div>

i did not get a screen asking for default character set  
the instructions ive found to chang it (my.cnf , \C) do not seem to  
take  
using the \C command while logged into mysql seem to change some of  
the character sets  
but if i \q then restart my mysl -u root connection, when i run show  
variables like ‘char%’; theyre all back to latin1

show how do i change it to utf8 for good?

---

<div class="post-metadata">

**Author:** ![dan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/eada6e/32.png) [@dan](https://www.ruby-forum.com/u/dan)\
**Post date:** [November 10, 2009, 1:56pm UTC](https://www.ruby-forum.com/t/mysql-rake-functions-failing/178705/4 "2009-11-10T13:56:55Z")

</div>

I use the MySQL Administrator gui, Options → Advanced.

[http://dev.mysql.com/downloads/gui-tools/5.0.html](http://dev.mysql.com/downloads/gui-tools/5.0.html)