Learning ruby on Mac - rake create error

[Kathy Koehler]

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
--
Posted via http://www.ruby-forum.com/.

[Rick]

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 Koehler <rails-mailing-l...@andreas-s.net>
wrote:

[dan]

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

<code>
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)

</code>

*** 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

<code>
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
</code>

[dan]

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

[Steve Wilhelm]

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

[Martin Streicher]

I had this same issue with an older project but not with a new
project, so I copied the newer database.yml file to the older project,
renamed the database in the file, and then things worked. My new entry
looks like this:

development:
adapter: mysql
encoding: utf8
reconnect: false

database: dev
pool: 5
username: strike
password: secret

[dan]

i still have not found a solution to this problem
i have reached out to a few sources for help
my most detailed list of issues can be found here:

http://railsforum.com/viewtopic.php?pid=113115

its very frustrating...cannot create a db using mysql on mac


On Nov 22, 7:28 am, Martin Streicher <martin.streic...@gmail.com>
wrote:

[fancybeast]

Using a different version of mysql solved this problem for me:

5.1.41 Mac OS X 10.5 (x86_64) --- doesn't work

5.1.41 Mac OS X 10.5 (x86) -- works

[Conrad Taylor]

--

I have successfully installed MySQL 5.1.41 on Snow Leopard using MacPorts 1.8.1 and the file

type is as follows:

/opt/local/bin/mysql5: Mach-O 64-bit executable x86_64

-Conrad

 

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 rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.