MySQL Forums
Forum List  »  Connector/ODBC

Re: Host Blocked Too Many Connections
Posted by: Bogdan Degtyariov
Date: February 05, 2017 07:49PM

Probably the max_connecti_errors number on the database server is low and just a few unsuccessful attempts blocked the host. This could be the problem even if the login/password are correct, but the Connector/ODBC used with MS Access is too old.

I agree that phpMyAdmin would be the best option because it is often running on the same host with the MySQL Server and the hosting provider makes sure it is properly configured.

Sometimes using the remote front-end such as LibreOffice is more convenient. In that case increasing max_connecti_errors should be considered:

https://dev.mysql.com/doc/refman/5.7/en/blocked-host.html

Options: ReplyQuote


Subject
Written By
Posted
Re: Host Blocked Too Many Connections
February 05, 2017 07:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.