To use MySQL with Ruby On Rails (Ruby 1.9.2 Rails 3.0.7) is ridiculous because Rails generates code that will not work without modification. Even when you tell Rails you want to use MySQL via the -d option the wrong and erroneous code is generated. How intelligent is that?
Make sure the code for MySQL for rails in properly installed. Open the command prompt and issue the following command.
gem install mysql
After the successful install go to your choice location where you store your applications and create your project.
Because Rails produces buggy and incorrect code you have to manually change all references of mysql2 to mysql in two files. The first file needing this modification is Gemfile and database.yml.
I have authored a Delphi GUI application that frees me from this command line drudgery and making changes to the required files. Let me know if such a tool interest you. If my response is respectable I will make the tool generally available.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems authored this article.