Re: Host Blocked Too Many Connections
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
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.