Home / server / Questions / 270258
Accepted
mik
Asked: 2011-05-17 09:49:12 +0800 CST

MySQL not accepting connections from WP

  • 772

I have a few servers running WordPress. I am using IIS with MySQL. One keeps faulting; I reset the MySQL server and it works well for a few hours and after that I start getting "Error establishing a database connection".

The MySQL is up and I can log in to it as root or regular user, locally or remotely. I see nothing special in SHOW PROCESSLIST;, but the aborted connections do increase.

I'm running on a Win2008R2; my other servers are MUCH busier - the one that is not working is my QA server. I copied the my.ini configuration from the working servers to make sure this server can handle as many connections (initially it was set much lower as it is not production; in the installation I also chose DEV server and not production server), but it doesn't help. Another thing that helps is mysqladmin flush-hosts from the command line.

Where should I look? What should I do?...

windows-server-2008 connection mysql iis-7.5 wordpress

1 Answers

  1. Best Answer

    http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html

    mysql> show variables;

    take a look variable max_connect_errors, you can try increase it.

    • 1