1句指令解決MySQL many connection errors

有時在開發程式的時候, 遇到了下面的錯誤信息 many connection errors

然後就連不了資料庫

message from server: "Host '192.168.88.8' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

這時候要到資料庫所在的電腦登入MySQL 並使用下面指令

顯示錯誤的次數:

SHOW variables like '%max_connect_errors%';

重設錯誤的次數並解除封鎖:

TRUNCATE TABLE performance_schema.host_cache;