錯(cuò)誤連接超過max_connect_errors 會(huì)被mysql報(bào)一個(gè)錯(cuò)誤,
MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
我個(gè)人理解為 mysql的一種防護(hù)機(jī)制,防止ip攻擊
原因:
同一個(gè)ip在短時(shí)間內(nèi)產(chǎn)生太多(超過mysql數(shù)據(jù)庫max_connection_errors的最大值)中斷的數(shù)據(jù)庫連接而導(dǎo)致的阻塞;
解決方法:
1、提高允許的max_connection_errors數(shù)量(治標(biāo)不治本):
修改max_connection_errors的數(shù)量為1000: set global max_connect_errors = 1000;
查看是否修改成功:show variables like '%max_connection_errors%';
2.直接flush hosts;