无法建立连接，因为目标计算机主动拒绝了它(PHP/WAMP) [英] No connection could be made because the target machine actively refused it (PHP / WAMP)

问题描述

注意:我意识到这可以看作是重复的，但是我已经查看了其他答复，但他们没有为我解决问题.

我最近在Windows 7上使用mysql插件安装了Zend Studio和Zend Server.

I have recently installed Zend Studio and Zend Server with the mysql plugin on Windows 7.

我不是合格的服务器管理员，但我也不是完全不称职；我全天致力于建立一个本地开发服务器"，以减少上传/下载时间.

I am not a qualified server administrator but neither am i completely incompetent; i have dedicated my day trying to get a local development 'server' up to cut down on upload/download times.

当我说服务器/机器时，我是指我的家用计算机

When I say server/machine i mean my home computer

我试图停止让mysql与Zend Server一起工作而陷入停顿.

I have come to a grinding halt trying to get mysql to work with Zend Server.

我一直收到的错误是(或冗长的):

The error I keep receiving is (or verbose):

#2002 Cannot log in to the MySQL server
or (if i change to 'config' authentication type)
#2002 - No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).

我尝试过:

• 将$ cfg ['Servers'] [$ i] ['host']从"localhost"更改为"127.0.0.1"
• 添加/删除$ cfg ['Servers'] [$ i] ['socket'] ='';
• 从cookie更改为配置身份验证类型
• 重新安装服务器和mysql
• 禁用防火墙
• 重启机器

Zend的方法是配置phpmyadmin设置屏幕" ...完成了，我不知道有多少次.

Zend's approach was to 'configure the phpmyadmin setup screen'... done that i don't know how many times.

在座的任何人都可以伸出援手，或指向我尚未尝试过的方向吗?

Can anyone on here lend a hand, or point me in a direction that I haven't tried yet?

推荐答案

1. 转到C:\ wamp \ bin \ mysql \ mysql [您的版本] \ data
2. 将"ib_logfile0"和"ib_logfile1"复制并保存在其他位置.
3. 删除"ib_logfile0"和ib_logfile1

帮了我大忙.希望它也对您有用.

Did the trick for me. hope it works for you too.

工作正常. 但是我们将不得不停止apache和mysql，我们需要退出xampp然后删除文件.成功删除时.现在启动xampp，它将正常工作..

Its working fine. But we will have to stop apache and mysql, We need to quit xampp and then delete file. when deleted successfully. now start xampp it will work properly..

这篇关于无法建立连接，因为目标计算机主动拒绝了它(PHP/WAMP)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！