如何解決網(wǎng)站錯(cuò)誤:host is blocked because of many connnection.....
2015-10-19 19:35:20
18702
1.網(wǎng)站打開的時(shí)候出現(xiàn)錯(cuò)誤:host is blocked because of many connnection errors;unblock with ‘mysqladmin
flush-hosts’如下圖:
2.分析:這是因?yàn)?span>mysql已經(jīng)得到了大量的主機(jī)(hostname)鏈接在中途被中斷了鏈接請(qǐng)求。在max_connect_errors次請(qǐng)求失敗后,mysql認(rèn)為是數(shù)據(jù)庫(kù)出錯(cuò),并且阻止了站點(diǎn)的鏈接。
有三種方法可處理:
(1)這時(shí)只要重啟下數(shù)據(jù)庫(kù)就可以了:
net stop mysql
net start mysql
(2)或者mysqladmin flush-hosts -uroot -p
(3)或者您可以修改max_connect_errors的值,默認(rèn)的是10
