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/.
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...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> 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 viahttp://www.ruby-forum.com/.
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>
so is this mysql default charset as latin1 really a problem?
I am having a similar problem. Did you find a solution? On Nov 8, 12:37 am, dan <mr.dan.ma...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> so is this mysql default charset as latin1 really a problem?
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 On Nov 13, 1:51 pm, Steve Wilhelm <st...-ic1OywNogUknEVtka5Vzhw@public.gmane.org> wrote:> I am having a similar problem. Did you find a solution? > > On Nov 8, 12:37 am, dan <mr.dan.ma...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > so is this mysql default charset as latin1 really a problem?-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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=.
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...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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 > > On Nov 13, 1:51 pm, Steve Wilhelm <st...-ic1OywNogUknEVtka5Vzhw@public.gmane.org> wrote: > > > > > I am having a similar problem. Did you find a solution? > > > On Nov 8, 12:37 am, dan <mr.dan.ma...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > so is this mysql default charset as latin1 really a problem?-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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=.
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 -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Fri, Dec 4, 2009 at 4:59 PM, fancybeast <hughha-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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 > > -- > >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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > >-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.