Connection Failed: Host ... Is Blocked Because of Connection Errors ... Flush Hosts
Issue
After clicking Test in the MySQL Connector/ODBC Data Source Configuration dialog box, you saw an error message similar to the following:
Connection failed: host 'YOUR-SERVER-NAME' is blocked because of connection errors; unblock with 'mysqladmin flush-hosts'
Cause
This issue can result from a recent virus or from issues with your network.
Solution
The following steps need to be performed on your server, either by physically logging into your server or by our technical support team via a remote desktop session.
1. After logging in to your server, open your Start menu and search for mysql.
Select MySQL 5.5 Command Line Client from the list of applications.
2. When prompted to enter a password, type landfx
The password is landfx – no spaces or caps.
3. Type the following command at the mysql command line:
FLUSH HOSTS;
Don't forget the semicolon at the end of the command.
Then press Enter.
The test should now be successful, and Land F/X should function without issue.
Contact
- Land F/X
Our software tailors AutoCAD® to the needs of landscape architects, irrigation designers, and other professionals. We automate your most tedious tasks and ensure accuracy, giving you more time to design.