Windows7 WAMP 64 位栈 MySQL 问题 [英] Windows7 WAMP 64-bit stack MySQL problems

问题描述

在这里使用本指南 ->http://www.elxis.org/guides/developers-guides/64bit-apache-php-mysql-windows.html

By using this guide here -> http://www.elxis.org/guides/developers-guides/64bit-apache-php-mysql-windows.html

解决出现的错误和问题，我有一个 apache、php 和 MySQL 堆栈，几乎可以在 Windows 7 上运行 - 都是 64 位.PHP 和 apache 工作正常，phpinfo 告诉我启用了 mysql 支持.

And hacking through the errors and issues that came up, I've got an apache, php, and MySQL stack almost working on Windows 7 - all 64 bit. PHP and apache are working just fine, and phpinfo tells me that mysql support is enabled.

现在问题来了.任何实际调用 MySQL 的 php 脚本都会给我一个连接重置"错误.

Now here's the problem. Any php script that actually calls MySQL gives me a "connection reset" error.

我尝试关闭防火墙；它没有任何区别.我试过将 libmysql 和 php_mysql 副本放在几个不同的地方，包括 apachein 和 Windowssystem32，但无济于事.

I've tried turning off my firewall; it made no difference. I've tried putting libmysql and php_mysql copies in a few different places, including apachein and Windowssystem32, to no avail.

这是 phpinfo 告诉我的:

This is what phpinfo tells me:

mysql
MySQL Support enabled
Active Persistent Links  0
Active Links  0
Client API version  5.1.44

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host localhost localhost
mysql.default_password no value no value
mysql.default_port 3306 3306
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

MySQL 正在运行，很明显它正在被 php 感知；当我将其关闭时，phpmyadmin 会适应.但是，当它打开时，当我尝试使用 phpmyadmin 登录时，出现连接重置"错误:页面加载时与服务器的连接已重置.

MySQL is on, and clearly it's being sensed by php; when I turn it off, phpmyadmin pitches a fit. When it's on however, and I try logging in with phpmyadmin, I get a 'connection reset' error: The connection to the server was reset while the page was loading.

我的错误日志什么也没告诉我.纳达.压缩.只是服务已经开启或关闭等等.

My error logs are telling me nothing. Nada. Zip. Just that services have been turned on or off, etc., etc.

有人知道如何让 PHPmyadmin 和其他 mysql 连接脚本正常工作吗??

Anybody know how I can get PHPmyadmin and other mysql connection scripts working??

推荐答案

PHP 解释器在 32-bit 和 64 位操作系统，但在 Microsoft Windows 上唯一的官方发行版是 32 位实现，在 64 位 Windows 平台上使用 Internet 信息服务 (IIS) 时需要 Windows 32 位兼容模式.自 PHP 5.3.0 起，可用于 MS Windows 的实验性 64 位版本.

http://wiki.php.net/internals/windows/releasenotes

问题是目前还没有适用于 Windows 的官方 64 位版本，请尝试 32 位版本，因为这应该可以解决您的问题.

The problem is there is no Official 64 Bit version for Windows yet, try the 32 bit version as this should solve your problem.

这篇关于Windows7 WAMP 64 位栈 MySQL 问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！