Learning ruby on Mac - rake create error

Rails
1

I can do a mysql -u root and then type in create database
restaurant_test, development, production but when I run

rake db:create:all I get:

(in
/Users/katherinekoehler/Documents/workspace/kkoehler/classes/ruby/lesson5/restaurant)
Couldn’t create database for {“socket”=>"/tmp/mysql.sock",
“reconnect”=>false, “encoding”=>“utf8”, “username”=>“root”,
“adapter”=>“mysql”, “host”=>“localhost”, “password”=>nil,
“database”=>“restaurant_development”, “pool”=>5}, charset: utf8,
collation: utf8_general_ci (if you set the charset manually, make sure
you have a matching collation)
Couldn’t create database for {“socket”=>"/tmp/mysql.sock",
“reconnect”=>false, “encoding”=>“utf8”, “username”=>“root”,
“adapter”=>“mysql”, “host”=>“localhost”, “password”=>nil,
“database”=>“restaurant_production”, “pool”=>5}, charset: utf8,
collation: utf8_general_ci (if you set the charset manually, make sure
you have a matching collation)
Couldn’t create database for {“socket”=>"/tmp/mysql.sock",
“reconnect”=>false, “encoding”=>“utf8”, “username”=>“root”,
“adapter”=>“mysql”, “host”=>“localhost”, “password”=>nil,
“database”=>“restaurant_test”, “pool”=>5}, charset: utf8, collation:
utf8_general_ci (if you set the charset manually, make sure you have a
matching collation)

My .yml files:

development:
adapter: mysql
encoding: utf8
reconnect: false
database: restaurant_development
pool: 5
username: root
password:
host: localhost
socket: /tmp/mysql.sock

/tmp/mysql.sock exists

My mysql process:

74 195 173 0 32:13.26 ?? 109:41.08 /sw/sbin/mysqld --basedir=/sw
–datadir=/sw/var/mysql --user=mysql
–pid-file=/sw/var/mysql/katherine-koehlers-macbook-pro.local.pid -u
root

I also did a sudo gem update mysql-ruby to make sure I had the latest
libraries.

I’ve spent hours on this. Any ideas?

Kathy

2

i was using sqlite for the past few projects and getting things
running smoothly enough
recently getting macports, git, installing a git module; geokit
turns out geokit has more functionality in mysql / postgress then
sqlite, namely distancing functions

i create the project as mysql, scaffold a location model then try to
run db:create
but i fail on rake db:create command

Couldn't create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"***", "adapter"=>"mysql", "database"=>"v3_development_2", "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)

*** used for username and password

i can login to mysql with the username and password
s displays current character set latin1
i can change to utf8, run the command and get same error
if i restart mysql, it returns to latin1

is character set really the issue?
do i need directory user permissions to create the db from rails?

rails 2.3.3
ruby 1.8.7
mysql 5.1.39

mysql Ver 14.14 Distrib 5.1.39, for apple-darwin9.5.0 (i386) using readline 5.1

Connection id: 438
SSL: Not in use
Current pager: stdout
Using outfile: ‘’
Using delimiter: ;
Server version: 5.1.39 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 14 min 32 sec
3

rake db:create:all works fine here:

/mystest 741 > mysql --version
mysql Ver 14.14 Distrib 5.1.31, for apple-darwin9.5.0 (powerpc) using
readline 5.1
/mystest 742 > gem list mysql

*** LOCAL GEMS ***

mysql (2.8.1)
/mystest 743 > cat config/database.yml

MySQL. Versions 4.1 and 5.0 are recommended.

Install the MySQL driver:

gem install mysql

On Mac OS X:

sudo gem install mysql – --with-mysql-dir=/usr/local/mysql

On Mac OS X Leopard:

sudo env ARCHFLAGS=“-arch i386” gem install mysql – --with-mysql-

config=/usr/local/mysql/bin/mysql_config

This sets the ARCHFLAGS environment variable to your native

architecture

On Windows:

gem install mysql

Choose the win32 build.

Install MySQL and put its /bin directory on your path.

And be sure to use new-style password hashing:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

development:
adapter: mysql
encoding: utf8
reconnect: false
database: mystest_development
pool: 5
username: root
password:
host: localhost

.
.
.

NOTE: the gem installs with: sudo gem install mysql

I can reproduce your error message if I hand in an incorrect username
or password so I’m guessing the utf8 and matching collation is
gibberish meant to confound the confusible;-()

On Sep 7, 9:10 am, Kathy K. [email protected]

4

so is this mysql default charset as latin1 really a problem?

5

I am having a similar problem. Did you find a solution?