Rails Mysql2 problem on ubuntu

最新推荐文章于 2024-10-11 18:08:42 发布

magic_dreamer

最新推荐文章于 2024-10-11 18:08:42 发布

阅读量91

点赞数

分类专栏： Scripts 文章标签： mysql2 socket ubuntu rails

本文链接：https://blog.csdn.net/magic_dreamer/article/details/83976811

版权

Scripts 专栏收录该内容

299 篇文章 0 订阅

订阅专栏

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