今天尝试用一台虚拟机去连另一台虚拟机的mysql时出现了报错.
ERROR 1129 (HY000): Host'192.168.2.128' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
这是由于一个ip在短时间内产生太多中断的数据库连接导致的.
解决:
1.增大连接数
#vi my.cnf
max_connections=1000
> set global max_connections=1000;
2.刷新连接的ip
# mysqladmin flush-hosts
> flush hosts;
阅读(3119) | 评论(0) | 转发(0) |