MySQL Blocked Becauase of Too Many Connections
Published October 2nd, 2009This morning we found out that one of our MySQL server is blocking connection for all our Web servers due to too many connections. We solved the problem of too many connections that were coming from the Web server but still MysQL had the Web hosts blocked.
To unblock, we had to run the following command on the MySQL server:
mysqladmin flush-hosts -u root -psecret
That worked like a charm!
If you found this post useful, please subscribe to our RSS feed. Thanks for visiting!
Leave a comment
Comment Policy: First time comments are moderated. Please be patient.