MySQL登录提示:host *.*.*.* is blocked because of many connection errors

登录myslq提示 host ... is blocked because of many connection errors;unblock with ‘mysqladmin flush-hosts’

原因:
同一IP在短时间内产生太多中断的数据库连接二导致的阻塞;

解决方法:
1、修改允许的max_connect_errors数量
show variables like ‘max_connect_errors’;
set global max_connect_errors = 1000;

2、临时解决办法:
1)flush hosts;
2)重启数据库

MySQL登录提示:host *.*.*.* is blocked because of many connection errorsMySQL登录提示:host *.*.*.* is blocked because of many connection errors 棠宁 发布了15 篇原创文章 · 获赞 1 · 访问量 1万+ 私信 关注
上一篇:asp.net core使用identity+jwt保护你的webapi(二)——获取jwt token


下一篇:python写文件时遇到UnicodeEncodeError: 'gbk' codec can't encode character...时处理办法