Issue with Placing server into Maintenance mode

[bsivavani]

Hi,

We are trying to place the server into maintenance mode through API using script, the script is working on other servers but it is failing from one host.

We are receiving below error while placing the server into maintenance mode.
Invoke-MySQLQuery : Exception calling "Open" with "0" argument(s): "Host 'XXXXX' is blocked because of many
connection errors; unblock with 'mysqladmin flush-hosts'"
At C:\SYSLAN\SYS\TOOLS\RWEST_Blackout\Nagios_Blackout\Nagios_Maintenance_OnPrem.ps1:346 char:17

When we search this error, we found below URL
https://chartio.com/resources/tutorials ... mazon-rds/

in the URL they mentioned run the command FLUSH ALL from MySQL promt.

Can you let us know if we can run this command on MySQL database ?

[scottwilkerson]

I have no idea what this script is or does

We are receiving below error while placing the server into maintenance mode.
Invoke-MySQLQuery : Exception calling "Open" with "0" argument(s): "Host 'XXXXX' is blocked because of many
connection errors; unblock with 'mysqladmin flush-hosts'"
At C:\SYSLAN\SYS\TOOLS\RWEST_Blackout\Nagios_Blackout\Nagios_Maintenance_OnPrem.ps1:346 char:17

I would attempt to contact the author if C:\SYSLAN\SYS\TOOLS\RWEST_Blackout\Nagios_Blackout\Nagios_Maintenance_OnPrem.ps1

[bsivavani]

Have you come across the command FLUSH ALL in mysql?

[scottwilkerson]

Have you come across the command FLUSH ALL in mysql?

No.

Sseveral other FLUSH commands, but not ALL