启动mysql启动成功,信息如下
071215 23:58:55 mysqld started
071215 23:58:55 InnoDB: Started; log sequence number 0 43665
071215 23:58:55 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.41-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Trustix MySQL RPMmysql.sock 在/var/lib/mysql/目录下如果在linux下输入mysql -p可以进入mysql进行任何操作,如查询,插入等等但如果用php连接数据库会出现如下错误信息:
[error] [client 192.168.0.225] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-onnect</a>]: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) in /home/httpd/html/include/phpfun.inc on line 14, referer: http://192.168.0.1/home/
该问题在本人一次重启mysql后出现,重启之前一切正常,请各位能看下问题所在吗?my.cnf的部分配置如下:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set = gbk[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4
default-character-set = gbk
skip-networking
log-bin=mysql-bin
server-id = 1[mysqldump]
quick
max_allowed_packet = 16M
default-character-set = gbk
[mysql]
no-auto-rehash
default-character-set = gbk[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout
071215 23:58:55 mysqld started
071215 23:58:55 InnoDB: Started; log sequence number 0 43665
071215 23:58:55 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.41-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Trustix MySQL RPMmysql.sock 在/var/lib/mysql/目录下如果在linux下输入mysql -p可以进入mysql进行任何操作,如查询,插入等等但如果用php连接数据库会出现如下错误信息:
[error] [client 192.168.0.225] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-onnect</a>]: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) in /home/httpd/html/include/phpfun.inc on line 14, referer: http://192.168.0.1/home/
该问题在本人一次重启mysql后出现,重启之前一切正常,请各位能看下问题所在吗?my.cnf的部分配置如下:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set = gbk[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4
default-character-set = gbk
skip-networking
log-bin=mysql-bin
server-id = 1[mysqldump]
quick
max_allowed_packet = 16M
default-character-set = gbk
[mysql]
no-auto-rehash
default-character-set = gbk[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout
肯定没有指定 SOCKET选项。
仔细检查一下代码
<?php
// we connect to localhost and socket e.g. /tmp/mysql.sock//variant 1: ommit localhost
$link = mysql_connect('/var/lib/mysql/mysql.sock ', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
// variant 2: with localhost
$link = mysql_connect('localhost:/var/lib/mysql/mysql.sock ', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
/var/lib/mysql/mysql.sock修改为/var/run/mysql/mysql.sock
重启mysql后正常,谢谢啦