由于许多连接错误而被阻止

由于许多连接错误而被阻止

本文介绍了主机“主机名"由于许多连接错误而被阻止;用'mysqladmin flush-hosts'解锁的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我的网站在本地"Wamp"服务器上运行良好.但是,将其上传到虚拟主机供他人使用后,会出现以下错误:

My website is working perfectly on a localhost 'Wamp' server. However, as soon as I upload it to my web host for others to use, I get the following error:

由于许多连接错误,主机'stats.starfish.arvixe.com'被阻止;使用"mysqladmin flush-hosts"取消阻止

我无法执行"flush-hosts"命令,因为我使用的是共享主机并且缺少特权.

I cannot perform a 'flush-hosts' command, since I am using a shared host and lack the privileges.

我已经在网上进行了广泛的搜索,但是对于可能导致我的连接错误的原因,我找不到确切的答案.该站点可以正常工作,但是一旦有多个人开始使用它,MySQL就会阻止我的Web主机,因为它存在太多的连接错误.

I've searched extensively online, and I can't find a solid answer as to what may be causing my connection errors. The site works for a bit, but as soon as multiple people start using it, MySQL blocks my web host because it has too many connection errors.

我是否可以访问或查看任何类型的日志,这些日志可以告知我造成连接错误的原因?

Is there any sort of log I can access or view that may inform me as to what is causing the connection error?

推荐答案

https://dev.mysql.com/doc/refman/5.0/zh-CN/blocked-host.html

您的问题是您不断尝试连接,但失败了.共享服务器被设置为保护自己免受这种行为的侵扰,并切断了您的联系.关闭应用程序一段时间,然后解决连接问题,然后再重新打开.

Your problem is that you are continually attempting to connect and you are failing. The shared server is set to protect itself from this behavior, and has cut you off. Turn off your application for a while and then resolve the connection problem before turning it back on.

在服务器上设置了您可以再次尝试之前的时间(可能在您看不见的地方).因此,每隔15分钟尝试一会儿,直到您可以尝试...

The amount of time before you are able to attempt again is set on the server, likely in a place you can not see. So try every 15 minutes for a while until you are allowed the attempt ...

我建议您使用一个备用的mysql服务器(也许在本地)进行练习,这样您就可以避免将来在此主机上看起来像是蛮力攻击.在打开服务"之前,请始终手动测试连接.

I would suggest a spare mysql server (perhaps locally) to practice with so you can avoid what appears to this host as a brute force attack in the future. Always test your connection manually before "turning on the service".

这篇关于主机“主机名"由于许多连接错误而被阻止;用'mysqladmin flush-hosts'解锁的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-11 10:27