How to fix mariadb-admin flush-hosts / mysqladmin flush-hosts Issues?

How to fix mariadb-admin flush-hosts / mysqladmin flush-hosts Issues?

Error  :  Host 'xxx.xxx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' / 'mariadb-admin flush-hosts'

Root cause :

The issue occurs when the number of connection errors from a host exceeds the server variable:
  1. max_connect_errors


Step 1: Run the flush-hosts command in the Database server

For MariaDB:

  1. mariadb-admin -u root -p flush-hosts

For MySQL:

  1. mysqladmin -u root -p flush-hosts



          New to M365 Manager Plus?
          New to M365 Manager Plus?
            New to RecoveryManager Plus?
            New to RecoveryManager Plus?
              New to Exchange Reporter Plus?
              New to Exchange Reporter Plus?
                New to SharePoint Manager Plus?
                New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • 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 Fix Node.js Agent Zip Extraction Issue on Windows

                        Overview From Node.js Agent version 5.4.1 (APM version 181000 and later) onwards, some users may experience issues extracting the agent zip file on Windows systems using the default extractor. Recommended Solution To properly extract the Node.js ...

                      • 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 ...

                      • WMI/DCOM Communication and Network Resolution Errors

                        Applicable WMI Error Codes 0x80070776 — The object exporter specified was not found. Overview This error occurs when AppManager is unable to establish WMI/DCOM communication with the target Windows server during monitor addition or data collection. ...

                      • Windows Monitoring - FAQ

                        This Knowledge Base article provides answers to frequently asked questions related to Windows Server monitoring through WMI. The articles are categorized based on the monitoring lifecycle to help you quickly identify the relevant troubleshooting ...
                      Related Products