How to Fix mysqladmin flush-hosts Error in Linux

How to Fix mysqladmin flush-hosts Error in Linux

Tutorial fix mysqladmin flush-hosts error in Linux.

In this article, we want to look at how to fix mysqladmin flush-hosts error in Linux.

If you encounter the following error in the Linux VPS server:

Host 'hostname' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

To fix this, you need to check the value set for “max_connect_errors” in the “my.cnf” file.For this purpose, follow the steps below:

Enter the “my.cnf” file with the following command:

nano /etc/my.cnf

Then set “max_connect_errors” as follows:

max_connect_errors=1000

If “max_connect_errors” does not exist in the “my.cnf” file, Add the following lines to the beginning of the file and save them:

[mysqld]
 max_connect_errors=1000

If you have any questions or problems, you can ask the Ask system to provide guidance.

Good Luck.

 

Use of this Site is subject to express terms of use. By using this site, you signify that you agree to be bound by these