I ran into this error while trying to get Ruby on Rails 3.1.1 which I installed from the Rails Installer to talk to MySQL. My stack is built from WAMP, so it might not have been as easily as it would be on a standlone MySQL installation.
Here is are the steps I took to fix it.
Edit Gemfile in project and add the following line.
gem 'mysql2', '< 0.3'
Rebuild the MySQL adapter with your version of MySQL.
gem uninstall mysql2 gem install mysql2 -- --with-mysql-config="C:/wamp/bin/mysql/mysql5.5.16/bin/mysql_config.pl"
Download the MySQL connector from the MySQL website.
http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick
Once you have the zip file, uncompress it and copy lib/libmysql.dll to the Ruby bin directory. Finally, go back to your Rails project and run the following command.
bundle install
I was finally then able to run a command such as the following.
rails generate model Something name:string
Without it throwing any errors up.
Don't have time to check my blog? Get a weekly email with all the new posts. This is my personal blog, so obviously it is 100% spam free.
Tags: mysql, rails, railsinstaller, ruby, ruby on rails, wamp
This entry was posted on Friday, August 24th, 2012 at 12:21 pm and is filed under Programming, Tech. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.