php测试文件如下：
|
1
2
3
4
5
6
7
8
9
10
11
|
<?php$con = mysql_connect("localhost","root","zengjie2");
if (!$con)
{ die('Could not connect: ' . mysql_error());
}else{ echo "ok";
}?> |
访问后提示：
|
1
2
|
Warning: mysql_connect(): No such file or directory in /usr/local/nginx/html/mysql.php on line 3
Could not connect: No such file or directory |
解决方法：
登陆mysql
输入status，输出如下
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
Connection id: 4
Current database:Current user: root@localhostSSL: Not in use
Current pager: stdoutUsing outfile: ''
Using delimiter: ;Server version: 5.1.73 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socketServer characterset: latin1Db characterset: latin1Client characterset: latin1Conn. characterset: latin1UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 14 min 29 sec
|
记下UNIX socket路径 /var/lib/mysql/mysql.sock
查看/tmp/mysql.sock,不存在这个文件，那么建个Link
|
1
2
|
cd /tmpln -s /var/lib/mysql/mysql.sock mysql.sock
|
重新访问php文件，成功连接。
以上是一种情况，另外一种情况： 存在/tmp/mysql.sock 但是不存在 /var/lib/mysql/mysql.sock
|
1
2
3
4
|
cd /var/lib
mkdir mysqlcd mysqlln -s /tmp/mysql.sock mysql.sock |