Rails Mysql2 problem on ubuntu

sillycat

Rails Mysql2 problem on ubuntu

My problem is mysql2 adapter problem.

>sudo apt-get install libmysql-ruby libmysqlclient-dev
>sudo apt-get gem install mysql2

>sudo gem install activerecord-jdbcmysql-adapter

>vi Gemfile
gem 'mysql2'
>bundle update
>bundle install

>rake db:create

error message:
luohua@ubuntu:~/workspace/railsexample$ rake db:create
Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2)
Couldn't create database for {"encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql2", "database"=>"example_test", "pool"=>5, "pas
sword"=>"kaishi", "socket"=>"tmp/mysql.sock"}, charset: utf8, collation: utf8_unicode_ci
Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2)
Couldn't create database for {"encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql2", "database"=>"example_development", "pool"=>
5, "password"=>"kaishi", "socket"=>"tmp/mysql.sock"}, charset: utf8, collation: utf8_unicode_ci

solution:
>sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
>rake db:create

Greate, it works.

references:
http://hideto.iteye.com/blog/69968