db create ERROR in "Creating a Rails 2.0 Ruby Weblog in 10 Minutes"

[tony chen]

Hey guys,
I'm new to both ruby on rails AND netbeans. I started following the tutorial

http://blogs.sun.com/divas/entry/creating_a_rails_2_0

and updated my netbeans with

ruby 1.8.6
rails 2.0

and then when following the tutorial and I get to the part where i'm creating the db....Run Rake Task > db > create. I get the following error

(in C:/Documents and Settings/Administrator/Desktop/rubyweblog)

Couldn't create database for {"encoding"=>"utf8", "username"=>"tony", "adapter"=>"mysql", "host"=>"localhost", "password"=>"tony", "database"=>"rubyweblog_development"}, charset: utf8, collation: utf8_general_ci (if you set the charset manually, make sure you have a matching collation). Any help would be greatly appreciated!

Thanks!
Tony

PS My yml file is very basic with the following

development:
adapter: mysql
encoding: utf8
database: rubyweblog_development
username: tony
password: tony
host: localhost

test:
adapter: mysql
encoding: utf8
database: rubyweblog_test
username: tony
password: tony
host: localhost

production:
adapter: mysql
encoding: utf8
database: rubyweblog_production
username: tony
password: tony
host: localhost

[rest]

I'm getting this same error. I'd appreciate hearing about how you solve this
problem. Thanks.
gk


tonylc wrote:

[John]

sure it's something simple, hope you fix it,

on a later note i should probably post my blogging engine to github, it runs fine on rails 2.1.1 / ruby 1.8.7,

will let you know when i do,




John.
www.red91.com


2008/10/14 rest <address-removed ([email]address-removed[/email])>

[Chris Kutler]

Hello Tony,

That is my blog. Sorry I took so long to reply. I have some questions
for you.

What is your operating system?

Can you open a terminal window on the root folder (rubyweblog) of the
project and try this command:

rake db:create

Do you get any error messages?

It looks as if MySQL or some other internal software has a problem with
UTF8. Did you set the encoding to UTF8, or was that in the database.yml
file created by the IDE?

tony chen wrote:

[sutter2k]

see
http://dev.rubyonrails.org/changeset/7718

[sherpa99]

I was getting the same exact error this morning and then realized that I hadn't started mysql.