我装的linux as4+apache5.2.3+php5.2.0+mysql5.0.27 ,服务以启动mysql,且命令行可进入Mysql,但是phpinfo没有mysql的信息,php程序无法连接mysql数据库。
我的my.cnf如下:
[mysqld]
#datadir=/var/lib/mysql
datadir=/usr/local/mysql/data
#socket=/var/lib/mysql/mysql.sock
socket=/tmp/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1 [mysql.server]
user=mysql
#basedir=/var/lib
basedir=/usr/local/mysql [mysqld_safe]
#err-log=/var/log/mysqld.log
err-log=/var/lib/mysql/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
pid-file=/var/lib/mysql/mysqld.pid
请高手指点!
我的my.cnf如下:
[mysqld]
#datadir=/var/lib/mysql
datadir=/usr/local/mysql/data
#socket=/var/lib/mysql/mysql.sock
socket=/tmp/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1 [mysql.server]
user=mysql
#basedir=/var/lib
basedir=/usr/local/mysql [mysqld_safe]
#err-log=/var/log/mysqld.log
err-log=/var/lib/mysql/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
pid-file=/var/lib/mysql/mysqld.pid
请高手指点!
安装PHP的时候加上参数:
./configure ...... --with-mysql=/usr/local/mysql
安装方法:
http://blog.csdn.net/mathematician/archive/2006/03/31/646073.aspx
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
socket = /var/run/mysqld/mysqld.sock
我也遇到过类似的问题,后来把两者的socket改的一致就解决问题了,楼主可以试一下。