Home > php教程 > php手册 > php连接mysql报错No such file or directory

php连接mysql报错No such file or directory

WBOY
Release: 2016-06-06 19:52:55
Original
2173 people have browsed it

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

<?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@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

 

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template