无法建立连接，因为目标机器主动拒绝(PHP/WAMP)

2021-11-20 00:00:00 mysql zend-server

注意:我意识到这可能被视为重复，但我查看了其他回复，但他们没有为我解决问题.

我最近在 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[your-version]\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..

相关文章