How install mysql in Ubuntu for Rails 3

gem   install   mysql2
Building native extensions.  This could take a while…
ERROR:  Error installing mysql2:
        ERROR: Failed to build gem native extension.

/ home/ kahwee/ .rvm/ rubies/ ruby-1.9.2-p0/ bin/ ruby extconf.rb
checking  for   rb_thread_blocking_region( ) …  yes
checking  for   mysql_query( )   in   -lmysqlclient… no
checking  for   main( )   in   -lm…  yes
checking  for   mysql_query( )   in   -lmysqlclient… no
checking  for   main( )   in   -lz…  yes
checking  for   mysql_query( )   in   -lmysqlclient… no
checking  for   main( )   in   -lsocket… no
checking  for   mysql_query( )   in   -lmysqlclient… no
checking  for   main( )   in   -lnsl…  yes
checking  for   mysql_query( )   in   -lmysqlclient… no
checking  for   main( )   in   -lmygcc… no
checking  for   mysql_query( )   in   -lmysqlclient… no
***   extconf.rb failed  ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/ or headers.  Check the mkmf.log  file   for   more
details.  You may need configuration options.

Provided configuration options:
         –with-opt-dir
         –without-opt-dir
         –with-opt-include
         –without-opt-include =${opt-dir} / include
         –with-opt-lib
         –without-opt-lib =${opt-dir} / lib
         –with-make-prog
         –without-make-prog
         –srcdir =.
         –curdir
         –ruby =/ home/ kahwee/ .rvm/ rubies/ ruby-1.9.2-p0/ bin/ ruby
         –with-mysql-config
         –without-mysql-config
         –with-mysql-dir
         –without-mysql-dir
         –with-mysql-include
         –without-mysql-include =${mysql-dir} / include
         –with-mysql-lib
         –without-mysql-lib =${mysql-dir} / lib
         –with-mysqlclientlib
         –without-mysqlclientlib
         –with-mlib
         –without-mlib
         –with-mysqlclientlib
         –without-mysqlclientlib
         –with-zlib
         –without-zlib
         –with-mysqlclientlib
         –without-mysqlclientlib
         –with-socketlib
         –without-socketlib
         –with-mysqlclientlib
         –without-mysqlclientlib
         –with-nsllib
         –without-nsllib
         –with-mysqlclientlib
         –without-mysqlclientlib
         –with-mygcclib
         –without-mygcclib
         –with-mysqlclientlib
         –without-mysqlclientlib

Gem files will remain installed  in   / home/ kahwee/ .rvm/ gems/ ruby-1.9.2-p0/ gems/ mysql2-0.2.6  for   inspection.
Results logged to  / home/ kahwee/ .rvm/ gems/ ruby-1.9.2-p0/ gems/ mysql2-0.2.6/ ext/ mysql2/ gem_make.out

To resolve it, install libmysqlclient-dev:

sudo   apt-get   install   libmysqlclient-dev

And now you can install mysql2 successful:

kahwee @ kahwee-desktop: / $ gem   install   mysql2
Building native extensions.  This could take a while…
Successfully installed mysql2-0.2.6
1 gem installed
Installing ri documentation   for   mysql2-0.2.6…
Installing RDoc documentation   for   mysql2-0.2.6.....

 

     数据库的链接在config/database.yml中， 请注意将其mysql置换为mysql2;

     转贴： http://i.justrealized.com/2010/install-mysql2-gem-ubuntu/