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