Openbsd 下面 mysql 报错socket '/var/run/mysql/mysql.sock
来源:互联网 发布:人工智能会议参会人员 编辑:程序博客网 时间:2024/06/05 16:30
#2002 - Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
道理很简单,因为你的mysql_connect是一个localhost,而不是你服务器的名字,如
果是localhost, PHP就会用mysql.sock文件,而不用正常的TCP连接。
apache在OpenBSD下都是chroot过了,这一点你可以 ps agx | grep httpd | grep parent 看到,chroot过apache根目录在/var/www,而你的mysql mysql.sock 文件在/var/run/mysql.
有两个解决方案:
1。mysql_connect 不用localhost,而是你的服务器名字www.yourserver.blablabla
2. 在 /etc/rc.conf 里的httpd,加"-u" httpd_flags="-u" 这样apache就不chroot了,不过我不喜欢这个方案,不安全。。。
man chroot , man rc.conf
- Openbsd 下面 mysql 报错socket '/var/run/mysql/mysql.sock
- Ubuntu14连接MySql报错“can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock'”
- mysql.sock -> /var/run/mysqld/mysqld.sock
- 错误: MySQL server through socket '/var/run/mysqld/mysqld.sock‘
- mysql报错unix:///var/mysql/mysql.sock
- centos6.5 mysql 报Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- zabbix安装 报错 socket '/var/lib/mysql/mysql.sock' (13)]
- Ubuntu上mysql连接报错Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- 解决mysql报错Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- MySQL连接报错:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- [ERROR] Could not create unix socket lock file /var/run/mysql/mysql.sock.lock
- 04-MySQL-Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- zabbix到安装界面报错" Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock"
- 解决mysql的Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- mysql left join,right join,inner join用法举例
- 众核技术报告会归来
- 统计软件全家福
- 异构并行
- 摘要的写法
- Openbsd 下面 mysql 报错socket '/var/run/mysql/mysql.sock
- Zappos:一个神话般的在线零售商
- 绪论的写法
- [SEO工具]收集整理的SEO工具,站长们必备良具!!
- 控件包含代码块(即 ),因此无法修改
- el简介及用法
- 诡异的问题,不如重启试试
- 杂记(一)——关于DoDataExchange 中相关联的类型变量
- ASP.Net 中Alert、Confirm、Prompt的用法