Mac OS 10.10 php不能连接mysql问题解决

最新推荐文章于 2019-07-11 19:38:02 发布

TerrenceRao

最新推荐文章于 2019-07-11 19:38:02 发布

阅读量1k

点赞数

分类专栏：技术相关

本文链接：https://blog.csdn.net/rct1985/article/details/44861489

版权

技术相关专栏收录该内容

42 篇文章 0 订阅

订阅专栏

本文介绍了一种在Ubuntu系统上解决Rails应用中MySQL连接失败的方法。通过创建/tmp/mysql.sock到/var/run/mysqld/mysqld.sock的软链接，可以有效解决因路径配置不匹配导致的连接错误。

摘要由CSDN通过智能技术生成

php连接数据库都没问题,升级到10.10这后, 突然连接不上了. 这个问题放了很久, 今天突然搜索到一篇文章.

用链接的方式解决了. 原文如下:

So you installed Ubuntu, got all excited about developing your Rails application on it, and then…

No such file or directory - /tmp/mysql.sock)

No matter what you do, database connection doesn’t work. You reinstall Rails (of course you installed it via “sudo apt-get rails”, right??), reinstall MySql, recreate the database schema, change root’s password, install Kubuntu instead of Ubuntu… But it doesn’t work.

The reason for this error is quite simple, really: somewhere along Ruby’s Mysql driver, mysql socket is expected to exist at /tmp/mysql.sock. But that’s not where it is in Ubuntu. If you take some time searching, you’ll notice that the .sock file is actually on /var/run/mysqld - and it’s called mysqld.sock instead.

In fact, if you Google it, there is a closed bug entry on Rails’ tracking system regarding that problem, and the suggested solution there is to change your database.yml to add a link to the correct socket. Something like:

production:
  adapter: mysql
  socket: /var/run/mysqld/mysqld.sock

Which is obviously not a good idea, since you’ll end up creating new projects, moving to a different OS or whatever - and everything will break again.

So I tried a small patchwork to fool mysql’s driver, and then it works nicely:

sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

That way you will actually HAVE a /tmp/mysql.sock file, as expected by mysql driver, and everything will connect just fine. Just like it’s meant to be. Amen!