gem install mysql problem in rails

Question

Im getting an error with a rails app.

The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.

And when i try to do gem install mysql it still doesnt work and im getting this error.

WARNING: Installing to ~/.gem since /Library/Ruby/Gems/1.8 and /usr/bin aren't both writable. WARNING: You don't have /Users/bartligthart/.gem/ruby/1.8/bin in your PATH, gem executables will not run.

I also tried this but it didn't work

sudo gem install mysql −− −−with−mysql−config≡/usr/local/mysql/bin/mysql_config

what could i do to install mysql?

Answer 1

you need to install this first:

apt-get install libmysqlclient-dev

Answer 2

Did you install the MySQL db server? If so, does this file actually exist?:

/usr/local/mysql/bin/mysql_config

If mysql isn't installed, install that first. Then make sure that the mysql_config script you point to is actually there.

Answer 3

What worked for me is adding this to ~/.bash_profile:

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

After installing the MySQL gem like this (64 bit version on an Intel osx 10.6):

export ARCHFLAGS="-arch x86_64" ; sudo gem install --no-rdoc --no-ri mysql -v 2.7 -- --with-mysql-dir=/usr/local --with-mysql-config=/usr/local/mysql/bin/mysql_config