How to fix mariadb-admin flush-hosts / mysqladmin flush-hosts Issues?
Reasons:
-
Application cannot connect to MariaDB/MySQL
-
Error: Host is blocked because of many connection errors
-
mariadb-adminormysqladminfails due to authentication issues -
Remote connections suddenly stop working
Root cause
The issue occurs when the number of connection errors from a host exceeds the server variable:
- max_connect_errors
Root cause
Step 1: Run the flush-hosts command in the Database server
For MariaDB:
mariadb-admin -u root -p flush-hosts
For MySQL:
mysqladmin -u root -p flush-hosts
New to ADSelfService Plus?
Related Articles
Import Certificates for MariaDB/MySQL Monitoring with SSL
Secure connections between Applications Manager and MySQL/MariaDB servers require SSL/TLS certificates to encrypt communication and optionally verify the server and client identities. By following this guide, users will learn how to generate, ...How to import certificates for monitoring MariaDB/MySQL DB Server with SSL authentication?
For MariaDB Server Go to AppManager UI --> Settings --> Manage Certificates --> Trust Certificates --> Keystore/Truststore --> Select cacerts Restart Applications Manager to verify SSL connectivity while using the MariaDB monitor. For MySQL DB Server ...Setting WMI access through Active Directory and Group Policy Object for non-admin user
In our case, we run Active Directory on Windows 2008 R2 and we want to scan the target machine which is Windows 2012 R2 machine. Our domain is called “APMCLU” and we name our dedicated WMI user-account “wmiuser”. First – Setting done from Active ...Steps to verify WMI access for Non-Admin Domain user
This guide provides how to enable and test WMI access with a regular domain user without generic admin rights. Make sure you have followed the steps in the article Setting WMI access through Active Directory & Group Policy Object. This ensures you ...How to perform migration to fix "ID out of allocated range" issue or unable to add managed server into admin server due to "server id does not match" error in Applications Manager
If the id value used internally for the monitors crosses the server id value specified in Settings -> Support -> Installation Information -> Server Id - Managed server, then you will get the following alert in Admin server: For existing Managed ...