Can't connect to local MySQL server through socket '/tmp/mys

软件和网站开发以及相关技术探讨
回复
webcgo
帖子: 101
注册时间: 2008-04-13 13:58

Can't connect to local MySQL server through socket '/tmp/mys

#1

帖子 webcgo » 2008-04-18 5:14

其实道理很简单,
"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)"
-->说明mysql.sock有问题,到/tmp去找,没有mysql.sock 文件;此时看下my.conf,
[mysqld] socket = /var/run/mysqld/mysqld.sock
-->说明socket的目标是/var/run/mysqld/mysqld.sock,MySQL启动是就到这里找socket啦,但偏偏要先从/tmp连接过去,真是多此一举,不得不

代码: 全选

ln -s  /var/run/mysqld/mysqld.sock  /tmp/mysql.sock 
[/code] 记住,不要在/tmp中自己新建一个mysql.sock文件[/b][/quote]
头像
astarring
帖子: 69
注册时间: 2008-11-02 17:10

Re: Can't connect to local MySQL server through socket '/tmp/mys

#2

帖子 astarring » 2009-05-29 8:21

我也是才是遇到这样类似的问题,不过我的是ubuntu mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
这是怎么回事?
HP台式机
Window7 Ubuntu 10.10双系统
头像
Randoman
帖子: 56
注册时间: 2007-10-15 17:57

Re: Can't connect to local MySQL server through socket '/tmp/mys

#3

帖子 Randoman » 2009-06-10 14:40

astarring 写了:我也是才是遇到这样类似的问题,不过我的是ubuntu mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
这是怎么回事?
同楼上的问题。我头大了。找了很多方法都没解决。而/var/run/mysqld目录下什么东西都没有。 :em20
mawanglin2008
帖子: 6
注册时间: 2011-10-19 21:02

Re: Can't connect to local MySQL server through socket '/tmp

#4

帖子 mawanglin2008 » 2011-12-15 0:20

我最近也遇到这个问题啊,和2楼一样,求解决,求帮助!!!
回复