运行环境:windows7+apache+php+mysql前天运行正常,昨天出现这种问题,年前也出现这种问题,无论怎么重新配置环境,都无济于事,后来打算用IIS跑,装到后来,不会用IIS跑ZendFramework的重写,于是又在IIS没卸载的情况下,让apache跑了8082和8083这两个端口,居然一切顺得,直到昨天,老问题又重现了,很无语,请各位大侠帮忙!问题现象:测试失败代码,无任何报错信息,页面反应是打不开页面<?php
$con = mysql_connect("localhost","root","zhufeng");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
else
{
echo "yes";
phpinfo();
}?>测试成功的代码<?php
$con = mysqli_connect("localhost","root","zhufeng");
if (!$con)
{
die('Could not connect: ' . mysqli_error());
}
else
{
echo "yes";
phpinfo();
}?>--------------------------------------------------------
发下phpinfo中mysql的信息
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.42 Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off --------------------------------------------------------
php.ini的部分设置情况:1.extension=php_mysql.dll extension=php_mysqli.dll都已打开
2.系统环境变量的path中已加入 php及ext的路径 (e:\php\php;e:\php\php\ext)请问各位大侠,这个怎么解决?谢谢
$con = mysql_connect("localhost","root","zhufeng");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
else
{
echo "yes";
phpinfo();
}?>测试成功的代码<?php
$con = mysqli_connect("localhost","root","zhufeng");
if (!$con)
{
die('Could not connect: ' . mysqli_error());
}
else
{
echo "yes";
phpinfo();
}?>--------------------------------------------------------
发下phpinfo中mysql的信息
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.42 Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off --------------------------------------------------------
php.ini的部分设置情况:1.extension=php_mysql.dll extension=php_mysqli.dll都已打开
2.系统环境变量的path中已加入 php及ext的路径 (e:\php\php;e:\php\php\ext)请问各位大侠,这个怎么解决?谢谢
有很多原因会引起类似的问题,比如硬盘满了,可以看下mysql的错误日志,有没有什么错误
100222 11:07:22 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100222 11:07:24 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100222 11:07:26 InnoDB: Started; log sequence number 0 55012
100222 11:07:26 [Note] Event Scheduler: Loaded 0 events
100222 11:07:26 [Note] E:\php\MySQL\bin\mysqld: ready for connections.
Version: '5.1.42-community' socket: '' port: 3306 MySQL Community Server (GPL)
关闭迅雷,bt,电驴等随机占用端口的软件,避免端口被占用。
telnet 3306端口,看是否能正常连接。
http://topic.csdn.net/u/20090920/22/14d4f597-b7d4-4c24-b0db-abb2956e66c3.html
<tr>
<td class="tit">用户名</td><td><input id="u_name" name="u_name" type="text" class="input_bg" /></td><td class="uu"> </td>
</tr>
<tr>
<td class="tit">密 码</td><td><input id="u_pass" name="u_pass" type="password" class="input_bg" /></td><td class="uu"> </td>
</tr>
<tr>
<td></td><td><input id="dl" type="submit" value="登录"/></td><td></td>
</tr>
</table>
这样不可以吗?
这和MYSQL有什么关系呢?年前跑得好好的,都开发完一个系统了,有次电脑被黑了,重装系统后,重做了环境,然后就出现MYSQL连接不上的情况了,后来很无语用IIS跑PHP,不过不会跑Zend,后来重做成apache+php+mysql+zend后,就正常了,从昨天开始,很奇怪地就又连接不了MYSQL了,具体什么原因,就不知道,页面反应就是打不开网页,断开连接,也没有错误提示。
已经开发过,如果你自己没改过环境和配置,那说明可能是你运行了什么软件或程序导致你的mysql有冲突了
改成display_errors = ON
重启apache 应该php页面就会显示错误了
是打开的,捕不到错误,页面就是直接打不开,服务器断开链接的那种,估计是一登录MYSQL,导致apache崩溃,页面反应出连不上服务器,所以就没有错误显示了