模版用iis在自己家电脑上做网站,万州集团网站建设,如何做网站创业,为网站添加注册功能主机被锁问题
描述#xff1a;Host ‘113.109.111.217’ is blocked because of many connection errors
原因#xff1a;同一个ip在短时间内产生太多中断的数据库连接而导致的阻塞#xff1b; 超过mysql数据库max_connection_errors的最大值#xff1b;
解决方法…主机被锁问题
描述Host ‘113.109.111.217’ is blocked because of many connection errors
原因同一个ip在短时间内产生太多中断的数据库连接而导致的阻塞 超过mysql数据库max_connection_errors的最大值
解决方法用管理员进入到数据库中 执行命令 flush hosts
示例
[shyCentOS ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37147
Server version: 5.7.38 MySQL Community Server (GPL)Copyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type help; or \h for help. Type \c to clear the current input statement.mysql flush hosts;
Query OK, 0 rows affected (0.00 sec)
