Ruby on Rails 3无法通过OSX上的套接字'/tmp/mysql.sock'连接到本地MySQL服务器 [英] Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on OSX

问题描述

我有一个标准的Rails3环境，RVM 1.2.9，Rails 3.0.5，Ruby 1.9.2p180，MySQL2 Gem 0.2.7，mysql-5.5.10-osx10.6-x86_64

I have a standard Rails3 environment, RVM 1.2.9, Rails 3.0.5, Ruby 1.9.2p180, MySQL2 Gem 0.2.7, mysql-5.5.10-osx10.6-x86_64

运行rake db:migrate创建数据库时出现的错误是:

Error I get when running rake db:migrate to create database is:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

config/database.yml具有

config/database.yml has

development:
  adapter: mysql2
  host: localhost
  username: root
  password: xxxx
  database: xxxx

确保这是我所缺少的简单东西.

sure it's something simple I'm missing.

推荐答案

首先，找到您的套接字文件:

First, to find your socket file:

mysqladmin variables | grep socket

对我来说，这给出了:

| socket                                            | /tmp/mysql.sock                                                                                                        |

然后，在您的config/database.yml中添加一行:

Then, add a line to your config/database.yml:

development:
  adapter: mysql2
  host: localhost
  username: root
  password: xxxx
  database: xxxx
  socket: /tmp/mysql.sock

这篇关于Ruby on Rails 3无法通过OSX上的套接字'/tmp/mysql.sock'连接到本地MySQL服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！