TIP: Instant Rails problems with MySQL


I've mentioned Instant Rails before, the one-step installer for Ruby on Rails for Windows that makes life excedingly easy for beginners? Well, as it turns out there's a problem using it with the included MySQL that makes the combination simply not work - every time you try to do something with MySQL from any of the Rails or Ruby commands you're greated by the loving message

Mysql::Error: Lost connection to MySQL server during query: SELECT version FROM schema_info

Lots of fun there. As it turns out the fix is remarkably easy, simply download the following zip file and follow the instructions in the included readme.txt file, which boil down to copying a single file to somewhere specific. Why this wasn't included in the final Instant Rails release I don't know, but at least the fix is easy.

Huge thanks to Jeroen Nijenhuis for putting this fix together - the Rails newbie world is forever in your debt!