MySQL & Rails in Windows

MySQL installation in Windows for Ruby on Rails usage can be problematic. With version 5.0, this seems to work. Upon installation, remember to execute:

gem install mysql

Following that, if you encounter error during rake db:migrate with the error indicating

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

you can try to solve it by copying the version 5.0 libmySQL.dll to your Ruby\bin folder.

libmySQL.dll is located in mysql\MySQL Server 5.0\bin directory.