还是不行啊,MYSQL我可以用MySQL-Front 登陆打开,
密码也修改成长了,
在MySQL-Front下建了一个数据库DVBBS
可还是提示
Dvbbs.php info: Can not connect to MySQL server
php_errormsg:
The URL Is: http://bbs.hongliu.org/install/install.php?language=sc_gbk&setupaction=chkenvironment
Errno: 1045
Error: Access denied for user 'dvbbs'@'localhost' (using password: YES)
You Can Get Help In: http://bbs.cndw.com
密码也修改成长了,
在MySQL-Front下建了一个数据库DVBBS
可还是提示
Dvbbs.php info: Can not connect to MySQL server
php_errormsg:
The URL Is: http://bbs.hongliu.org/install/install.php?language=sc_gbk&setupaction=chkenvironment
Errno: 1045
Error: Access denied for user 'dvbbs'@'localhost' (using password: YES)
You Can Get Help In: http://bbs.cndw.com
密码 1213456789
呵呵,我很菜.请问,怎么样确认我的PHP能连上MYSQL数据库,如何确认啊.
检查你的php.ini查看里面extension=php_mysql.dll这一行
把前面的;(分号)给去掉,重新起动你的IIS或者apache
php版本 5.1.5
ZendOptimizer-2.5.5
;Note that ODBC support is built in, so no dll is needed for it.
;Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
;extension folders as well as the separate PECL DLL download (PHP 5).
;Be sure to appropriately set the extension_dir directive.extension=php_mbstring.dll
extension=php_bz2.dll
extension=php_curl.dll
extension=php_dba.dll
extension=php_dbase.dll
extension=php_exif.dll
extension=php_fdf.dll
extension=php_filepro.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_ifx.dll
extension=php_imap.dll
extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mcrypt.dll
extension=php_mhash.dll
extension=php_mime_magic.dll
extension=php_ming.dll
extension=php_mssql.dll
extension=php_msql.dll
extension=php_mysql.dll
extension=php_oci8.dll
extension=php_openssl.dll
extension=php_oracle.dll
extension=php_pgsql.dll
extension=php_shmop.dll
extension=php_snmp.dll
extension=php_sockets.dll
extension=php_sqlite.dll
extension=php_sybase_ct.dll
extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
我按网上的教程全部去掉了,放在WINDOWS目录下的
用户 DVBBS
if(!Mysql_connect("localhost","root",""))
echo "连接数据库失败";
elseif(!Mysql_select_db("wear"))
echo "打开数据库失败";
else
echo 'ok';
?>放到你的web根目录,运行,如果出现ok则表示连接成功
if(!Mysql_connect("localhost","dvbbs","123456789"))
echo "连接数据库失败";
elseif(!Mysql_select_db("dvbbs")) //mysql5是否支持数据库名大写?
echo "打开数据库失败";
else
echo 'ok';
?>
文件内容:
<?php
if(!Mysql_connect("localhost","root","123456789"))
echo "连接数据库失败";
elseif(!Mysql_select_db("wear"))
echo "打开数据库失败";
else
echo 'ok';
?>
一个root
一个DVBBS
密码都是123456789
这句是连接库..应该是 elseif(!Mysql_select_db("dvbbs")) //或者DVBBS这要看你建库的名字了
一个MYSQL
一个test
我现在改成 elseif(!Mysql_select_db("mysql")) 了
还是不能连接.
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
;mysql端口号
mysql.default_port = 3306; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =; Default host for mysql_connect() (doesn't apply in safe mode).
;mysql主机
mysql.default_host = localhost; Default user for mysql_connect() (doesn't apply in safe mode).
;用户名
mysql.default_user = root; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
;密码
mysql.default_password = 123456789; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off
一个MYSQL
一个test
我现在改成 elseif(!Mysql_select_db("mysql")) 了
还是不能连接.*******楼主的MYSQL没有正常打开.参考我上面的话.还有有一个文件libmysql.dll有没有拷贝到system32目录下了.如果这些都做了,还是不成.那....汗一个
; Allow or prevent persistent links.
mysql.allow_persistent = On; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port = 3306; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host = localhost; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user = root; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password = 123456789; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off
libmysql.dll拷过去了,IIS也重起了N次.MYSQL服务、也重起了.php.ini 也修改了.
真的只有汗一个..
会不会和我的WIN2003 是盗版有关.
<?php
if(!Mysql_connect("localhost","root","123456789"))
echo "连接数据库失败";
elseif(!Mysql_select_db("mysql"))
echo "打开数据库失败";
else
echo 'ok';
?>
显示OK了.DVBBS还是装不上,还是提示:
Dvbbs.php info: Can not connect to MySQL server
php_errormsg:
The URL Is: http://bbs.hongliu.org/install/install.php?language=sc_gbk&setupaction=chkenvironment
Errno: 1045
Error: Access denied for user 'dvbbs'@'localhost' (using password: YES)
You Can Get Help In: http://bbs.cndw.com
PHP默认安装目录:C:\php
PHP版本:PHP 4.3.10 下载地址:http://www.php.net/downloads.php (Windows Binaries)
Mysql版本:mysql-4.0.22-win 下载地址:http://dev.mysql.com/downloads/
zend :Zend Optimizer v2.5.5 (可选安装)首先将php压缩包解压到c:\php目录下,
先 php.ini-dist改名为php.ini
然后 php.ini 和php.exe复制到winnt目录...
php4ts.dll和php4isapi.dll(这个在sapi目录中)复制到winnt/system32 目录..........
*************************************好象没有说支持到什么版本,
这个是官网的帖子,是不是我的PHP版本太高了
iasky(C#_ASP_PHP) 说的对,dvbbs的配置文件没有设置好,
谢谢lzkd(浪子快刀) (我马上给分.
太感谢你们了.谢谢.
默认的配置文件是认为他们在同一级目录下
所以去掉分号还是找不到文件,估计要在前面加上目录名
extension = ext\php_mysql.dll