解除账号延迟响应限制

方法1： 重启MySQL实例

方法2： 调整系统变量connection_control_failed_connections_threshold的值。

mysql> SELECT * FROM  INFORMATION_SCHEMA.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS;+-------------------+-----------------+| USERHOST          | FAILED_ATTEMPTS |+-------------------+-----------------+| 'test'@'192.168%' |               5 |+-------------------+-----------------+1 row in set (0.00 sec)mysql> set global connection_control_failed_connections_threshold=2;Query OK, 0 rows affected (0.00 sec)mysql> SELECT * FROM  INFORMATION_SCHEMA.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS;Empty set (0.00 sec)

卸载插件plugin

mysql> UNINSTALL PLUGIN CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS; mysql> UNINSTALL PLUGIN CONNECTION_CONTROL;