我是网络开发和RoR的全新手 – 一个超级棒！ – 我正在通过lynda.com参加在线RoR课程.很高兴加入StackOverflow社区,非常感谢路障的一些帮助.

当我设置我的基本应用程序并成功运行一些迁移时,MySQL和localhost工作了好几周,但今天我在启动rails服务器并在浏览器中查看http://localhost:3000/时遇到MySQL错误：

Mysql2 :: Error(无法通过套接字’/tmp/mysql.sock’连接到本地MySQL服务器'(2))：

我不认为我已经改变了我的环境中的任何相关内容,所以我想知道我是否需要更新宝石或类似的东西？

我已经在谷歌和StackOverflow上找了好几个小时了,现在仍然无法弄清楚这里出了什么问题,以及如何解决它.其他解决方案似乎与新设置有关,而不是与莫名其妙地打破的工作设置有关.

这是一些背景：

从我的config / database.yml：

development:

adapter: mysql2

encoding: utf8

reconnect: false

database: simple_cms_development

pool: 5

username: simple_cms

password: XXXXXXXXX

socket: /tmp/mysql.sock

几周前,当MySQL和localhost工作正常时,我保存了一个命令行：

Last login: Mon Aug 15 21:34:23 on ttys000

sdemessieres$cd sites/simple_cms

sdemessieres$pwd

/Users/sdemessieres/sites/simple_cms

sdemessieres$rails server

=> Booting WEBrick

=> Rails 3.0.7 application starting in development on http://0.0.0.0:3000

=> Call with -d to detach

=> Ctrl-C to shutdown server

[2011-08-22 22:28:01] INFO WEBrick 1.3.1

[2011-08-22 22:28:01] INFO ruby 1.8.7 (2009-06-12) [universal-darwin10.0]

[2011-08-22 22:28:01] INFO WEBrick::HTTPServer#start: pid=66952 port=3000

Started GET "/" for 127.0.0.1 at Mon Aug 22 22:28:20 -0400 2011

Processing by DemoController#index as HTML

等……(从这里工作得很好)

但是今天我尝试了相同的命令并收到错误：

Last login: Mon Sep 5 12:13:22 on ttys000

sdemessieres$cd sites/simple_cms

sdemessieres$pwd

/Users/sdemessieres/sites/simple_cms

sdemessieres$rails server

=> Booting WEBrick

=> Rails 3.0.7 application starting in development on http://0.0.0.0:3000

=> Call with -d to detach

=> Ctrl-C to shutdown server

[2011-09-05 12:33:09] INFO WEBrick 1.3.1

[2011-09-05 12:33:09] INFO ruby 1.8.7 (2009-06-12) [universal-darwin10.0]

[2011-09-05 12:33:09] INFO WEBrick::HTTPServer#start: pid=11027 port=3000

Started GET "/" for 127.0.0.1 at Mon Sep 05 12:33:41 -0400 2011

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

Rendered /Library/Ruby/Gems/1.8/gems/actionpack-3.0.7/lib/action_dispatch/middleware/templates/rescues/_trace.erb (0.8ms)

Rendered /Library/Ruby/Gems/1.8/gems/actionpack-3.0.7/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (1.7ms)

Rendered /Library/Ruby/Gems/1.8/gems/actionpack-3.0.7/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (6.3ms)

所以我从训练中回到了数据库笔记,并尝试从我以前运行但不再使用的命令行连接到MySQL：

sdemessieres$pwd

/Users/sdemessieres/sites/simple_cms

sdemessieres$which mysql

/usr/local/mysql/bin/mysql

sdemessieres$mysql --version

mysql Ver 14.14 Distrib 5.5.13, for osx10.6 (i386) using readline 5.1

sdemessieres$mysql -u root -p

Enter password:

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

sdemessieres$

一个StackOverflow thread给了我这个线索,但它似乎只是强调了我的设置是正确的.

sdemessieres$mysql_config |grep -- --socket

--socket [/tmp/mysql.sock]

正如我所说,我是一个初学者,所以任何帮助将不胜感激,谢谢！