mysql - 氮气.io :moving rails app to mysql

Question

我需要将我的应用程序从 sqlite 迁移到 mysql。我遵循了那个指南

http://help.nitrous.io/mysql/

安装好mysql，这是我的yaml文件

developement:
  adapter: mysql2
  encoding: utf8
  database: dev-db
  pool: 5
  timeout: 5000

test:
  adapter: mysql2
  encoding: utf8
  database: test-db
  pool: 5
  timeout: 5000

production:
  adapter: mysql2
  encoding: utf8
  database: prod-db
  pool: 5
  timeout: 5000

当我尝试执行 rake db:create 时出现此错误

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "database"=>"test-db", "pool"=>5, "timeout"=>5000}, charset: utf8, collation: utf8_unicode_ci
(if you set the charset manually, make sure you have a matching collation)

我需要做什么？

Answer 1

你需要在database.yml中添加一个socket

获取套接字:

mysqladmin variables | grep socket

这让我在我的系统 (OSX) 上:

socket: /tmp/mysql.sock

在 Linux 上:

socket: /var/run/mysqld/mysqld.sock