database flushs-the-host

Problem:

When you try to access the MYSQL database thru sql editor, such as aqua. it failed to connect, and the error message show as :

This happened usually caused by max_connect_errors errors occur successively for the given host while connecting to the MYSQL server, so that MYSQL assumes that something is wrong and blocks the host from further connection requests. So, there is a need to flush the host tables to enable durther connection attempts from the host.

Solution:

1) You may need to to connect the PuTTY to flush the host before you can access to the database.

Note: PyTTY is and SSH and telnet client, developed originally by Simon Tatham for the Windows platform. PuTTY is open source software that is available with source code and is developed and supported bt a group of volunteers. (https://www,putty.org/)

2) Download and install the PuTTY, and login to PuTTY on SSH with the SSH host and port.

3) Then login with the SSH login id and password to the server, then you will see the login successfully as follows:

4) Then, you will need to login to the database to flush-host. To do that, at the command prompt, type this "mysql -u root -p".

5) After that, key in the password for the database access. Once sucessfully login, you will see the following:

6) Which it lead you to the SQL prompt, then type in "flush hosts;" to flush the host.

7) And the result showed "Query OK, 0 rows affected (0.00 sec)".

8) Once done, type "exit" to exit the SQL, then type "exit" again to exit from the PuTTY.

9) Now you can try to access your database again.

Prepared by Sim dated 3 Dec 2018