Bug #101949 Add rate-limit functionality to max_connect_errors

• Submitted: 10 Dec 2020 8:25
• Modified: 10 Dec 2020 8:30
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Connection Handling
• Severity: S4 (Feature request)
• Version: 8.0.22
• OS: Any
• CPU Architecture: Any

[10 Dec 2020 8:25] Daniël van Eeden

Description:
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html#blocked-host

Now if max_connect_errors is hit a host is blocked manual action is needed to unlock.

However I think it would be better to either:
* Gradually slow down authentication when over `max_connect_errors`
* Automatically re-allow logins after a hold-down timer (e.g. 10m)

How to repeat:
See description

[10 Dec 2020 8:30] MySQL Verification Team

Hello Daniël,

Thank you for the reasonable feature request!

regards,
Umesh