启动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
解决方案 »
- Substring 截取
- can't not update table 'szs_pick' in stored function/trigger because it is alrea
- 这样的数据库怎么设计?
- 删除数据表
- MySQL缺省的root改了密码后,不起作用
- 启动mysql报错,怎么回事?
- 我在java中怎样取得2001-10-11以后的所有记录
- 如果有一条命令错误,那么批处理中所有的命令都不会不执行?
- 有一个签到表,现在要拿到最后连续签到的天数,并排序,求这个sql语句该怎么写啊
- [已解决]关于mysql-connector-odbc-5.1.13-win32.msi安装成功后,ODBC数据源管理器无法显示该MySql驱动的问题解决
- 如何将表名赋值给一个变量或者一组数组?
- mysql在linux下安装(基础)
肯定没有指定 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后正常,谢谢啦