我又有问题了！ - Chinaunix

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/usr/local/mysql/var/mysql.sock' (13) in /usr/local/apache/htdocs/index.php on line 2
失败!
Warning: mysql_close(): no MySQL-Link resource supplied in /usr/local/apache/htdocs/index.php on line 5

# find / -name "mysql.sock"
/usr/local/mysql/var/mysql.sock

<?php
$link=mysql_connect('localhost','root','');
if(!$link) echo "失败!";
else echo "成功!";
mysql_close();
?>

# ls
bin          info          libexec       mysql-test    sql-bench
include       lib          man          share          var
# cd var
# ls
.localdomain.err       mysql-bin.000003       mysql-bin.000008
.localdomain.pid       mysql-bin.000004       mysql-bin.000009
mysql                mysql-bin.000005       mysql-bin.index
mysql-bin.000001       mysql-bin.000006       mysql.sock
mysql-bin.000002       mysql-bin.000007       test

# The following options will be passed to all MySQL clients
[client]
#password    = your_password
port          = 3306
socket       = /usr/local/mysql/var/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port          = 3306
socket       = /usr/local/mysql/var/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64

# ./mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.27-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

TEST                         RESULT
-------------------------------------------------------
alias                         [ pass ]
alter_table                   [ pass ]
analyse                      [ pass ]
analyze                      [ pass ]
ansi                         [ pass ]
archive                      [ skipped ]
archive_gis                   [ skipped ]
auto_increment                [ pass ]
backup                      [ pass ]
bdb-alter-table-1             [ skipped ]
bdb-alter-table-2             [ skipped ]
bdb-crash                   [ skipped ]
bdb-deadlock                [ skipped ]
bdb                         [ skipped ]
bdb_cache                   [ skipped ]
bdb_gis                      [ skipped ]
bench_count_distinct          [ pass ]
bigint                      [ pass ]
binary                      [ pass ]
binlog                      [ skipped ]
blackhole                   [ skipped ]
bool                         [ pass ]
bulk_replace                [ pass ]
case                         [ pass ]
cast                         [ pass ]
check                         [ pass ]
client_xml                   [ pass ]
comments                      [ pass ]
compare                      [ pass ]
compress                      [ pass ]
connect                      [ pass ]
consistent_snapshot          [ skipped ]
constraints                   [ pass ]
count_distinct                [ pass ]
count_distinct2             [ pass ]
^Z
Suspended
#

原帖由 HonestQiao 于 2007-7-18 14:59 发表
localhost改为127.0.0.1看看。

::1 localhost.localdomain localhost
127.0.0.1 localhost.localdomain localhost
192.168.81.130 .localdomain
192.168.81.130 .localdomain.

System	FreeBSD .localdomain 6.2-RELEASE FreeBSD 6.2-RELEASE #0: Fri Jan 12 10:40:27 UTC 2007 root@dessler.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386
Build Date	Jul 17 2007 13:54:56
Configure Command	'./configure' '--prefix=/usr/local/php' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--with-mysql=/usr/local/mysql' '--disable-debug' '--with-libxml'
Server API	Apache 2.0 Handler
Virtual Directory Support	enabled
Configuration File (php.ini) Path	/usr/local/lib
Loaded Configuration File	/usr/local/lib/php.ini
PHP API	20041225
PHP Extension	20060613
Zend Extension	220060519
Debug Build	no
Thread Safety	enabled
Zend Memory Manager	enabled
IPv6 Support	enabled
Registered PHP Streams	php, file, data, http, ftp, compress.zlib
Registered Stream Socket Transports	tcp, udp, unix, udg
Registered Stream Filters	string.rot13, string.toupper, string.tolower, string.strip_tags, convert., consumed, convert.iconv., zlib.*