Host 'hostname' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
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:
Host 'stats.starfish.arvixe.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
I cannot perform a 'flush-hosts' command, since I am using a shared host and lack the privileges.
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?
Answer
https://dev.mysql.com/doc/refman/5.0/en/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.
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 ...
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".