Rake db:migrate fails

Rails
1

i run the command:

rake db:migrate

but i get the error of:

Mysql::Error: query: not connected: SELECT version FROM
schema_migrations

i already checked my database.yml:

development:
adapter: mysql
database: my_data
username: root
password: key123
encoding: utf8
host: localhost

and as far as i can see its complete. checked google and they said make
sure that i can access the mysql. using the command line i was able to
verify that i can access it. checked windows services to make sure that
mysql is on it and i was able to confirm it too. so right now i dont
know why when i perform the rake command it doesnt push through.

please do advise me on this issue. also some additional information

ruby 1.8.6
rails 2.3.2
gems 1.3.3
MySQL 5.1.37
Windows Vista

2

Have you created the databases you need?

On Tue, Sep 1, 2009 at 2:34 PM, Jason

3

yeah i have.

someone directed me to this site

and the solution made by jsidnell worked for me. thankfully

Kevin Jones wrote:

Have you created the databases you need?

On Tue, Sep 1, 2009 at 2:34 PM, Jason