問題說明:通過mysql命令連接mysql數(shù)據(jù)庫的時候報了ERROR 1129的錯誤琳彩;
錯誤說明:ERROR 1129 (HY000): Host 'mysql02' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
錯誤原因:同一個ip在短時間內(nèi)產(chǎn)生太多中斷的數(shù)據(jù)庫連接而導(dǎo)致的阻塞(超過mysql數(shù)據(jù)庫max_connection_errors的最大值)
解決方法:[root@mysql01 script]# mysqladmin flush-hosts -h 127.0.0.1 -uroot -p
Enter password:
轉(zhuǎn)自:http://www.linuxidc.com/Linux/2014-11/109031.htm