您好,欢迎访问一九零五行业门户网

php连接mysql报错No such file or directory

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
php测试文件如下:
1
2
3
4
5
6
7
8
9
10
11
访问后提示:
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@localhost
ssl:     not in use
current pager:   stdout
using outfile:   ''
using delimiter:    ;
server version:  5.1.73 source distribution
protocol version:   10
connection:  localhost via unix socket
server characterset:    latin1
db     characterset:    latin1
client characterset:    latin1
conn.  characterset:    latin1
unix 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 /tmp
ln -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 mysql
cd mysql
ln -s /tmp/mysql.sock mysql.sock
其它类似信息

推荐信息