Rails Mysql2 problem on ubuntu

最新推荐文章于 2025-12-18 16:55:18 发布

原创最新推荐文章于 2025-12-18 16:55:18 发布 · 134 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql2 #socket #ubuntu #rails

Scripts 专栏收录该内容

299 篇文章

订阅专栏

文章详细介绍了在Ubuntu环境下解决Rails项目中使用MySQL2适配器时遇到的问题，包括安装相关依赖、修改Gemfile及运行数据库创建任务等步骤，最终成功解决无法连接本地MySQL服务器并通过socket的问题。

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